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

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

?
--
PeteCresswell

in a macro
columns(7).hidden=true

--
Don Guillett
SalesAid Software
[email protected]
"(Pete Cresswell)" <[email protected]> wrote in message
news:[email protected]...
> 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....
>
> ?
> --
> PeteCresswell

Pete

Columns(7).EntireColumn.Hidden = True


Gord Dibben Excel MVP

On Fri, 04 Feb 2005 14:21:04 GMT, "(Pete Cresswell)" <[email protected]> wrote:

>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....
>
>?

Per Gord Dibben:
>Pete
>
>Columns(7).EntireColumn.Hidden = True

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