From VBA: How to select a column by column number instead of letter?

  • Thread starter (Pete Cresswell)
  • Start date
P

(Pete Cresswell)

I'm in MS Access and don't know from column letters - all my constants are in
terms of column number.

I'd like to select, say, column number 7 and hide it....

?
 
P

(Pete Cresswell)

Per Gord Dibben:
Pete

Columns(7).EntireColumn.Hidden = True
Click to expand...

Thanks Gord, thanks Don...
I was trying
..Columns(7).Select
..Selection.Hidden=True.
 

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

From VBA: How to select a column by column number instead of letter? 2
lookup and return column number 2
Repeat value in column A by number in column B in column C 10
Changing column reference for number of formulas at once 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Pull a column header from a row of numbers 1
Convert Column number to a letter? e.g. Column 203 = GU 11
How to create a column of pseudo random numbers with probability ' 2

Top