Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting range
David,
In VBA? If so, Dim cCols As Long cCols = Cells(1, Columns.Count).End(xlToLeft).Column Columns(3).Resize(1, cCols - 2).EntireColumn.Select -- HTH Bob Phillips "david" wrote in message ... I am trying to select some columns. The problem is that the number of columns will change. I want to know how I can select from column C until the last column with data. I do not want to select column A or B. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Help with selecting a range... | Excel Programming | |||
Help with selecting a range... | Excel Programming | |||
selecting a range | Excel Programming |