VBA Lesson 1

Comment #3

LottoMining — Fri, 21 Dec 2007 20:44:34 GMT

Below is another Excel VBA building block to add to your useful building blocks. I've re-used the construct inside the For ... Next loop across a few files over the years. I apologize if the HTML formatting of this window forced a line or two to the next line. Sub LoopThis() dim i as integer, Rwct as integer, AColumn as string, BColumn as string, CColumn as string ' the User Defined Function will need to be saved in a module to call the IsOdd Function <br... [ More ]

Comment #2

time*treat — Fri, 21 Dec 2007 17:05:28 GMT

Heh, I still use 'GOTO' and line numbers, too.

Comment #1

Tenaj — Thu, 20 Dec 2007 20:59:25 GMT

But thank you for this - I will print it out. I have a programming background (BASIC) so it shouldn't be that difficult for me - After all VB is BASIC with pictures.

Original Blog Entry: VBA Lesson 1

GASMETERGUY — Thu, 20 Dec 2007 18:54:29 GMT