run marco without selecting a sheet

[tim963]

How can this be done without selecting the”Elevator” sheet, I need to run it when I am on another sheet
Application.ScreenUpdating = False
Sheets("Elevator").Select
Range("H2").AutoFill Destination:=Range("H2:H3000"), Type:=xlFillDefault
Application.ScreenUpdating = True

 

[Ivan F Moala]

<pre/>
Application.ScreenUpdating = False
With Sheets("Elevator")
.Range("H2").AutoFill Destination:=.Range("H2:H3000"), Type:=xlFillDefault
End With
Application.ScreenUpdating = True
</pre>

 

[tim963]

Ivan, thanks