columns name

Posted by amroo on August 22, 2001 12:05 AM

Hi everybody,
I have a list of letter in a combobox, when i click on one, i get the letter in Range("AX1"), so i want the columns nammed as the letter to be selected.
This is a part of my macro.
Col = Range("AX1").Value
Columns(" & Col:Col & ").Select
i wrote this but there is a mistake in the second line, can someone help me?
amroo

Posted by Alex on August 22, 2001 7:16 AM

Amroo,

Try making the second line as follows-
Columns(" & Col & ":" & Col & ").Select

Alternatively, if it's always just the one column, you probably only need-
Columns(" & Col & ").Select

Alex

Posted by amroo on August 23, 2001 11:09 PM

Thanks Alex, but !!!!