What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-03-15 05:15:29
vba should i use .value .value2
'Go with: Range.Value2 '<------Best way 'It is almost always the best choice to read from or 'write to an Excel cell or a range... from VBA. 'Each of the following can be used to read from a range: v = [a1] v = [a1].Value v = [a1].Value2 v = [a1].Tex... Add solution -
VBA 2022-03-11 22:50:03
vba mod function floating point number
'VBA does have the 'Mod' operator: MsgBox 5 Mod 2 '<--displays: 1 (5 ÷ 2 has a REMAINDER of 1) 'But bear in mind that it returns an integer value... always. MsgBox 11.5 Mod 3 '<--displays: 0 (But it should be 2.5) 'And in... Add solution -
VBA 2022-03-05 23:30:12
xl vba test 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 -
VBA 2022-03-05 11:55:05
excelvba is bit set in 64-bit longlong integer
'Extremely fast VBA function to test if a specified bit is set 'within a 64-bit LongLong integer. 'Bits are numbered from 0 to 63, so the first (least significant) bit 'is bit 0. 'Note: we do not inspect bit 63, the sign bit. 'Note: the LongLong data t... Add solution -
CSS 2022-03-03 05:30:45
navbar in css
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Navbar</title> <style> body { margin: 0; } .navbar{ padding: 15px; background-color: grey; display: flex; justify-... Add solution -
CSS 2022-03-03 04:20:04
wordpress remove sticky header
.navbar-fixed-top { position: absolute; } Add solution -
VBA 2022-03-02 18:35:20
vba left shift operator
'Many programming languages have a bitwise left-shift operator: << 'VBA does not. However, it can be emulated in a performant function: Function ShiftLeft1&(ByVal n&) ShiftLeft1 = 2& * (n And 1073741823): If n And 1073741824 Then Sh... Add solution
Best helpers
Ranking is empty