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 Don Guillett:
Gord and I sent you a macro solution for EXCEL as this is an Excel ng.

Worked like a champ from MS Access.

Only problem I had was a little RCI....thought the command wasn't working, then
found that applying column formatting after the command restored visibility to
true. Move the command to the end of the routine and the formatting stuck.

Thanks again.
 

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

Top