how to do it in one line?

B

Bobby

Worksheets("Sheet1").Select
Cells(3, 2).Select

Sheets("Sheet1").Cells(3, 2).Select
This give me a: Select method of Range class failed
 
D

Dave Peterson

application.goto worksheets("sheet1").cells(3,2), scroll:=true

If you're selecting, the correct workbook has to be active. And the worksheet
needs to be active before you can select a range.
 
B

Bobby

Dave said:
application.goto worksheets("sheet1").cells(3,2), scroll:=true

If you're selecting, the correct workbook has to be active. And the worksheet
needs to be active before you can select a range.
Click to expand...
Thank you Sir.
 
Top