Column Number of Named Column

V

Venus1331

Joined
Apr 18, 2010
Messages
1
Reaction score
0
Hi, I'm using VBA to create some macros in excel 07. I've named several columns and would like to get the column number associated with these names in the VBA code by referencing the names so that I don't have to hard code the column numbers. Is there a way to get the column number by referencing it's name without a particular cell in the column being active?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reference format and column name 1
Reference Column of Named Cell vba 6
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
insert row into named column 1
Numbers showing Up Centered in Cell ? 1
select a range in a column 4
Return column number from column header text 4
Cross-Referencng numbers between worksheets 3

Top