Setting a Range using a cell

[SBF12345]

Im having trouble finding the syntax to correctly define a range variable.

I am receiving an error on the lower of the two lines. These lines both exist within a with statement.

If .Cells(bb, "A").value = sampleVar Then    
                Set TblRng = .Range(Cells(bb, "A"), Cells(bb, "A").End(xlToRight))

Thanks!

 

[jim may]

.Range(.Cells(bb, "A"), .Cells(bb, "A").End(xlToRight))       'note addition of "."s twice.

 

[SBF12345]

Got it, thanks!