What do you want to save?
Add Code snippet
New code examples in category VBA
-
Lavios 2021-09-08 18:15:02
vba check if certain bits are set in longlong integer
'Fast VBA function to test if specific bits are set 'within a 64-bit LongLong integer. 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... Add solution -
Ron Jensen 2021-09-08 00:02:02
excel vba check if certain bits are set in 64-bit longlong integer
'If n is a 4-byte Long Integer, the Low (Left) Word is: If n And &H8000& Then LoWord = n Or &HFFFF0000 Else LoWord = n And &HFFFF& End If 'If n is a 4-byte Long Integer, the High (Right) Word is: HiWord = (n And &HFFFF0000)... Add solution -
Peter Bike 2021-09-07 09:08:01
vba excel delete every other row
Sub Delete_Even() Application.ScreenUpdating = False lr = Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row If lr Mod 2 = 0 Then Else lr = lr - 1 End If For i = lr To 1 Step -2 Rows(i & ":" & i)... Add solution -
Chandlerone 2021-09-06 16:35:03
excelvba long integer to binary string
Function LongToBits$(ByVal n&) Dim i& LongToBits = "00000000000000000000000000000000" If n And &H80000000 Then Mid$(LongToBits, 1, 1) = "1" n = n And Not &H80000000 End If For i = 32 ... Add solution