What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-01-23 22:01:27
excel vba clean non breaking space
'VBA function to clean data from range and return an array. This 'function does NOT use loops: Function CleanMAX(r As Range) CleanMAX = Replace("trim(clean(substitute(|,char(160),"" "")))", "|", r.Address) ... Add solution -
VBA 2022-01-23 06:05:16
excel vba convert text YYYYMMDD to date
'In Excel we sometimes need to work with imported dates that 'are of the form: YYYYMMDD, for example: 20200325. 'Excel needs numbers (not text) for plotting charts and calculations. 'VBA function to convert text in YYYYMMDD format to real Excel dates: ... Add solution -
VBA 2022-01-23 05:41:43
excel vba big hex string to decimal string
'VBA function to convert a hexadecimal string into a decimal. Uses 'the Decimal Variant subtype to allow for much larger values than the 'worksheet function HEX2DEC() or CLng("&h" & HexVal) can achieve. It 'returns an UNSIGNED Decimal i... Add solution -
Html 2022-01-22 15:16:26
bootstrap navbar
<nav class="navbar navbar-expand-lg navbar-light bg-light"> <a class="navbar-brand" href="#">Navbar</a> <button class="navbar-toggler" type="button" data-toggle="collapse"... Add solution -
VBA 2022-01-22 14:55:20
excel vba date to unix timestamp and vice versa
'VBA functions to convert between Excel and Unix date-times. 'These work on Windows and optionally the Mac: Function UnixDateTime#(ExcelDateTime As Date, Optional Mac As Boolean) Dim OSOffset: OSOffset = IIf(Mac, 24107, 25569) UnixDateTime = (Ex... Add solution -
VBA 2022-01-22 05:16:08
vba convert endianess
'Extremely fast VBA function to convert a LONG value from Little-Endian 'to Big-Endian byte order representation, and vice versa: Function ConvertEndianness&(ByVal n&) ConvertEndianness = (((n And -16777216) \ 16777216) And 255&) Or _ ... Add solution -
VBA 2022-01-22 05:00:57
xlvba check if specific bits set in byte
'Fast VBA function to test if specific bits are set 'within a Byte. If ALL specified bits are set then this function 'returns True. If ANY of the specified bits are not set then 'this function returns False. 'Bits are numbered from 0 to 7, so the first ... Add solution
Best helpers
Ranking is empty