Solved: Why using Range() works but Cells() doesn't??

[nathan2314]

Hi,

I need to select a range but needed to define a dynamic variable as things change. My variable is call endcol_d and it is the column I need to put in the range.
So I have

basebook.Sheets("Protect Population").Range(Cells(5, endcol_d), Cells(5, endcol_d + 1)).Select

But that doesn't work. It gives and error. But when I test it using Range("") for one instance it works. basebook.Sheets("Protect Population").Range("B5:C5").Select
How can I make it work using Cells??

Appreciate any help!!

[Bob Phillips]

You need to dot qualify everything



With basebook.Sheets("Protect Population")

.Range(.Cells(5, endcol_d), .Cells(5, endcol_d + 1)).Select
End With

[nathan2314]

Ah that fixed it! Thanks!!
:clap:

[kemas]

endcol_d = 4
ThisWorkbook.Sheets(1).Range(Cells(5, endcol_d), Cells(5, endcol_d + 1)).Select

[mdmackillop]

You can also use Resize
basebook.Sheets("Protect Population").Cells(5, endcol_d).Resize(,2).Select