Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compare 2 columns of numbers and place the matched numbers in a 3r | Excel Discussion (Misc queries) | |||
split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
Find similar numbers from two columns of numbers | Excel Discussion (Misc queries) | |||
Numbers in columns | Excel Discussion (Misc queries) | |||
Numbers in Columns | Excel Discussion (Misc queries) |