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-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 -
VBA 2022-01-22 02:56:23
xlvba check if bit is 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 -
VBA 2021-11-12 14:28:12
excel vba check if specific bits are set in longlong
'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 -
VBA 2021-10-26 14:22:12
xl vba check if 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 -
VBA 2021-10-15 04:32:06
vba inspect if bit is 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 -
VBA 2021-10-12 12:51:03
a macro to safe excel sheet to csv
Sub saveSheetToCSV() Dim myCSVFileName As String Dim tempWB As Workbook Application.DisplayAlerts = False On Error GoTo err myCSVFileName = ThisWorkbook.Path & "\" & "CSV-Exported-File-" & VBA.Format(... Add solution -
VBA 2021-10-03 11:05:02
excel vba error 424 object required when calling sub
'Excel VBA Error 424: Object required when calling sub. 'Error 424 is raised when an object is required but not provided. 'For the following Sub an argument of type Range is required. A Range is 'an object in Excel VBA. So when calling this Sub, the ca... Add solution -
VBA 2021-09-15 05:39:02
excel vba range.text
'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
Best helpers
Ranking is empty