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
[VBA]
basebook.Sheets("Protect Population").Range(Cells(5, endcol_d), Cells(5, endcol_d + 1)).Select[/VBA]

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

Appreciate any help!!

[Bob Phillips]

You need to dot qualify everything

[vba]

With basebook.Sheets("Protect Population")

.Range(.Cells(5, endcol_d), .Cells(5, endcol_d + 1)).Select
End With
[/vba]

[nathan2314]

Ah that fixed it! Thanks!!

[kemas]

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

[mdmackillop]

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