how to do it in one line?

[Bobby]

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

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

 

[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.

 

[Bobby]

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.

Thank you Sir.

 

[Bearacade]

What cells are you trying to select