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

[(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....

?

 

[Don Guillett]

in a macro
columns(7).hidden=true

 

[Gord Dibben]

Pete

Columns(7).EntireColumn.Hidden = True


Gord Dibben Excel MVP

 

[(Pete Cresswell)]

Per Gord Dibben:

Pete

Columns(7).EntireColumn.Hidden = True

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