What do you want to save?
Add Code snippet
New code examples
-
VBA 2021-10-21 16:52:04
excel vba exit do loop infinite
'VBA has the Exit Do statement to exit a Do Loop: Do c = c + 1 If c = 750 Then Exit Do Loop While i < 1000 '------------------------------------------------------------------- 'Note: If multiple Do Loops are nested, Exit Do transfers ' ... Add solution -
VBA 2021-10-21 02:07:09
excel vba binary string to hexidecimal string
'Fast VBA function to convert binary string to hexadecimal string... Function BinToHex$(bin$, Optional groupBy& = 1) Dim c&, i&, j&, hNdx&, nibble&, bits$, s$ Dim b() As Byte, h() As Byte Static bHexChars() As Byte, po... Add solution -
VBA 2021-09-11 07:16:03
excel vba convert number to binary string
'VBA function to convert number to binary string: Function DecToBin$(ByVal n&) Do DecToBin = n Mod 2 & DecToBin n = n \ 2 Loop While n End Function '------------------------------------------------------------------- 'N... Add solution -
VBA 2021-09-02 22:52:01
excel vba exit for next loop
'In VBA how to exit a For Next loop when a condition 'is met: use Exit For. For i = 1 To 1000 c = c + 1 If c = 750 Then Exit For Next 'Exit For can also be used inside a For Each loop: For Each r In [A1:A10] c = c + c If r.Value = "Hi&qu... Add solution