C-based and Java languages, on the other hand, do not store the length and have the '\0' (null) terminator to signal that the string ended. Because of that, getting the length in VBA is fast -- …

Oct 21, 2012 · I was studying some vba code and came across this: If DblBalance <> 0 Then I can't figure out what operator this is, any help would be appreciated.

3 days ago · Visual Basic for Applications (VBA) is an event-driven programming language which was first introduced by Microsoft in 1993 to give Excel 5.0 a more robust object-oriented …

See my solution based on UsedRange and VBA arrays to find the last cell with data in the given column -- it handles hidden rows, filters, blanks, does not modify the Find defaults and is quite …

Block 2 looks like an imitation of a Try/Catch block. It should be okay, but it's not The VBA Way. Block 3 is a variation on Block 2. Block 4 is a bare-bones version of The VBA Way. I would …

Aug 28, 2012 · How can I get a range of cells selected via user mouse input for further processing using VBA?

With ActiveWorkbook.Connections("XMLTable") .Name = "XMLTable" .Description = "" End With ActiveWorkbook.Connections("XMLTable").refresh The class ActiveWorkbook.Connections …

VBA has two functions: TypeName and TypeOf (TypeOf does not have a VBA documentation article, but the function exists nonetheless). However, for a good example of their use, you can …

Heck, I wrote so much VBA code at one time (before CS and IT were a thang) that I couldn't even recognise that I was the one who wrote some of it. Appreciate the intellectual exercise 25 …

Dec 30, 2011 · VBA does not have a Continue or any other equivalent keyword to immediately jump to the next loop iteration. I would suggest a judicious use of Goto as a workaround, …