Trouble with Select Method

[eAlchemist]

Is there something I don't know about successive select methods? The following code yields an unexpected (at least I don't expect it) result:

Sheet.Activate
Columns("A:X").Select
Selection.EntireColumn.Hidden = False

Do While ColumnsToHide(arraycount) <> "None"

Columns(ColumnsToHide(arraycount)).Select

If I ?Selection.Address in the immediates window here, I get $B:$X

Does this make sense to anyone? What am I doing wrong?

Thanks,
Chris

 

[eAlchemist]

Oh...
ColumnsToHide(arraycount) = "M:M"

 

[xlbo]

why bother with selections ??
There is avery good FAQ in the FAQs area on this

Your code can be re-written as:

Columns("A:X").EntireColumn.Hidden = False

Do While ColumnsToHide(arraycount) <> "None"

Columns(ColumnsToHide(arraycount)).Select



Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question