Select cell on inactive sheet

[Rudi]

Is there a way to select a cell on an inactive sheet?
IF I am on another sheet and run the code below, it debugs on the select line. I don't need to select the cell, but I do want to move to A1 so when the sheet is selected it shows A1 active.
I could do it with a sheet_activate event, but I would like to avoid events if possible.
Any other way to do it?
TX

Code: Select all

Sub ClearStaffCosts()
      Worksheets("StaffCosts").Rows("2:1000").Delete
      Worksheets("StaffCosts").Range("A1").Select
End Sub

[HansV]

No, you can only select a cell on the currently active sheet. What objection do you have to using the Worksheet_Activate event?

[Rudi]

No objection to the event...
I was simply trying to keep all the code grouped to on standard module. Silly I suppose if the functionality is there...but i just wanted to confirm.
TX.