MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel
Topic starter
I've found a work around for what I want to do, but would like to understand why this doesn't work.
In a VB Macro Sub I have.
ActiveSheet.Column(9).Select
and it selects the entire worksheet rather than just Column 9?
If I record a macro and select just column 9 I get the above code, so why doesn't it work stand alone?
Posted : 12/01/2009 11:31 am
try activesheet.Column(9).EntireColumn.select
or activesheet.cells(9,1).entirecolumn.select
something along those lines i think...
Posted : 12/01/2009 11:32 am
also, your line should be
ActiveSheet.Columns(9).Select
i.e Columns, not Column
that should work too.
Posted : 12/01/2009 11:34 am
Topic starter
'fraid not
Something more subtle is going on, even with the right syntax it selects the entire worksheet.
Posted : 12/01/2009 11:42 am
