Using Variable in Range selection

[losamfr17]

Hi,

I want to grab rngCopy in my loop of sheets.
Problem: the code below selects all cells between columns C & H.
Desired result: I want to ONLY select cells between C thru D AND cells in H but not the cells in between (just like this code would if rngCopy=9 -- Sheets(i).Range("C7:D9, H7:H9").select).

Any idea how to make that happen?

Dim rngCopy As Range

Set rngCopy = Sheets(i).Range("C7:D" & rowsCopy, "H7:H" & rowsCopy)


Sheets(i).Range("C7:D" & rowsCopy, "H7:H" & rowsCopy).Select

 

[Legacy 98055]

You were close.

Sheets(i).Range("C7:D" & [B]rowsCopy & ",[/B]H7:H" & rowsCopy).Select

 

[losamfr17]

You were close.

Sheets(i).Range("C7:D" & [B]rowsCopy & ",[/B]H7:H" & rowsCopy).Select

Cool
Thank you Sir! I learned something new thanks to you.