 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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?
try activesheet.Column(9).EntireColumn.select
or activesheet.cells(9,1).entirecolumn.select
something along those lines i think...
also, your line should be
ActiveSheet.Columns(9).Select
i.e Columns, not Column
that should work too.
'fraid not
Something more subtle is going on, even with the right syntax it selects the entire worksheet.