Refer to column in range statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. How can I refer to the column in a range statement? For instance, the
column could be "AO" and I can get the column number, but I don't know how to
refer to it in the following Range statement. Note that the column will
change. I do have a variable called "ColNum"

Range("B1:AO4")

Thanks,
Mike.
 
Range("B1",.cells(4,colnum))

would be one way.
Hi. How can I refer to the column in a range statement? For instance, the
column could be "AO" and I can get the column number, but I don't know how to
refer to it in the following Range statement. Note that the column will
change. I do have a variable called "ColNum"

Range("B1:AO4")

Thanks,
Mike.
Click to expand...
 
You must log in or register to reply here.

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

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
VBA set thick borders around non empty cells in range 0
Range Statement in chart 2
Problem with a loop and column references 27
Using Select Case on Single column only 1
best way to express the range "column N to column M"? 7
range names 4
Copy columns and paste with blank column between 5

Back
Top