Columns by numbers
I cannot work out how to refer to a group of columns by numbers.
this doesn't work or any varaition using Columns intead of Range:
Dim startCol as Byte, endCol as Byte
Range(Columns(startCol), Columns(startCol + 1), Columns(endCol)).AutoFit
Listing each column separately works but how can I group them on 1 line?
Columns(startCol).AutoFit
Columns(startCol +1).AutoFit
Columns(endCol).AutoFit
Could someone please help?
Geoff
|