ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   selecting range (https://www.excelbanter.com/excel-programming/276199-re-selecting-range.html)

Bob Phillips[_5_]

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





All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com