How in the World Does this NOT WORK!?!? Referancing a Cell Value in VBA Code

[rdsmit1]

x = Range("b2").Value
ThisWorkbook.Worksheets("Sheet1").Range("x").Value.Select


where the cell b2 in the worksheet has the value bt6 entered into it.

 

[phagan]

x = Range("b2").Value
ThisWorkbook.Worksheets("Sheet1").Range("x").Value.Select


where the cell b2 in the worksheet has the value bt6 entered into it.

Try it without the quotes around the x.

 

[rdsmit1]

Got it!

x = ThisWorkbook.Worksheets("Sheet1").Range("B1").Value
ThisWorkbook.Worksheets("Sheet1").Range(x).Select