How can I Select a hidden sheet within a macro?

[ktalamantez]

I would like to keep the Report Data sheet hidden, but need to execute the macro below upon opening the workbook. Is there some way to revise the Sheets Select statement below to make this happen?

Sub APOpStmtFill()

Sheets("Report Data").Select

With Range("A4:A" & Range("B" & Rows.Count).End(xlUp).Row)
.Value = Application.Clean(.Value)
Range("A4:A" & Range("B" & Rows.Count).End(xlUp).Row).SpecialCells(4).FormulaR1C1 = "=R[-1]C"
End With
End Sub

[bsalv]

select and activate are unnecessary actions, so forget them.

Please Login or Register  to view this content.