Select Range by Dynamic Attribute

[Jasvindra]

Hi Team,


Columns("C2:" & ColumnLetter & rwMax).Select

I am trying to select from C2:G16

But Not able to do so with Dynamic values.

 

[Joe4]

If you are using "Columns", there is no row component.
So just use:

Columns("C:" & ColumnLetter).Select

 

[Fluff]

Try

Range("C2", Cells(rwmax, ColumnLetter)).Select

 

[Jasvindra]

Please Ignore. Was using Column instead of Range

 

[Jasvindra]

Thanks Fluff for your quick Reply

 

[Joe4]

fIn looking at fluff's reply, it is unclear on whether you are trying to select the whole columns, or only specific rows in those columns.
I was assuming it was "Columns" (thinking, why else would you be using "Columns"?), but that maybe I should have not assumed that.

If you want the entire columns, my solution will work.
If you want just specific rows in those columns, Fluff's will do what you want.


EDIT: I see you clarified it while I was typing this up.