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

  • Thread starter Thread starter (Pete Cresswell)
  • Start date 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....

?
 
Gord and I sent you a macro solution for EXCEL as this is an Excel ng.
 
Per Don Guillett:
Gord and I sent you a macro solution for EXCEL as this is an Excel ng.
Click to expand...

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

Hide Row Numbers/Column Letter in VBA 1
From VBA: How to select a column by column number instead of letter? 3
Hide Column Letters and Row Numbers in VBA 2
lookup and return column number 2
Convert Column number to a letter? e.g. Column 203 = GU 11
Pull a column header from a row of numbers 1
Repeat value in column A by number in column B in column C 10
Unique #s in column, need multiple associated numbers in columns 5

Back
Top