Running Macro on a Different Worksheet

[phelbin]

I'm using VBA to find the row under LastRow and then clear the selection.

Sub Macro2()
Dim LastRow As Integer
    LastRow = Cells(Rows.Count, "A").End(xlUp).Row
    If LastRow = 0 Then LastRow = 1
    Rows(LastRow + 1).Select
    Selection.ClearContents
End Sub

The code works perfectly, but only on the current worksheet. Is it possible to do this on another worksheet without having to go to that worksheet and run another macro?

In this case it would be 'Sheet1 (2)'


Thanks!!

[phelbin]

Nevermind. I figured it out.

Dim LastRow As Integer
    Sheets("Sheet1 (3)").Select
    LastRow = Cells(Rows.Count, "A").End(xlUp).Row
    If LastRow = 0 Then LastRow = 1
    Rows(LastRow + 1).Select
    Selection.ClearContents
End Sub

[ozbod]

Try prefacing the code with the sheet in question

Sub Macro2()
Dim LastRow As Integer
    LastRow = Sheets("Sheet1 (2)").Cells(Sheets("Sheet1 (2)").Rows.Count, "A").End(xlUp).Row
    If LastRow = 0 Then LastRow = 1
    Sheets("Sheet1 (2)").Rows(LastRow + 1).ClearContents
End Sub