VBA to say use sheet B if sheet A doesn't exist

Hello,

I have a macro issue that another person who left my company wrote. In the current macro, data is being pulled from a tab called "Summary Sheet"

However, in the set of files (this is pulling from) the sheet has been renamed to "Report"


I do not want to rename several hundred tabs in different workbooks, so how would I tell the VBA code to pull the data from "Report" if it cannot locate tab "Summary Sheet" ?

Here is the code that references "Summary Sheet"


wbk2.Activate
Sheets("Report").Activate
Range("d30").Select
Application.CutCopyMode = False
Selection.Copy

thank you, how do I write this in code:

"if it does use "Summary Sheet" if not, use "Report" sheet."

Please Login or Register  to view this content.

Or declare worksheet object variable and set that variable... I prefer this method as it can reduce code line.

Please Login or Register  to view this content.

sorry that still isn't working:

Dim ws As Worksheet

If IsObject(wbk2.Sheets("Summary Sheet")) Then
Set ws = wbk2.Sheets("Summary Sheet")
Else
Set ws = wbk2.Sheets("Report")
End If



wbk2.Activate
Sheets("Report").Activate
Range("d30").Select
Application.CutCopyMode = False
Selection.Copy


the error is on the sheets ("report"). Activate line

.... so ws is set in if statement.

You'd just use ws.Activate instead of Sheets("Report").Activate.