What is the easiest way to find the column reference number to use in VBA code? For instance column "C" would be 3. But when referencing column "AF" it's a pain in the ***. Any ideas?
What is the easiest way to find the column reference number to use in VBA code? For instance column "C" would be 3. But when referencing column "AF" it's a pain in the ***. Any ideas?
Hi, Jiptastic,
you could either apply the worksheetfunction Column() in the sheet to do so or in VBA use something like
And changing the Options for Column Header Display as Numbers (R1C1) could be yet another way.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Awesome. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks