Joined
·
11,541 Posts
I have a macro that can be run multiple times on a workbook. The first time it is run, it creates multiple worksheet objects.
Code:
And then I have code like this to create the worksheet and name it:
Code:
I am working on modifying the program so it can be run multiple times, concatenating new data each time it is run. Is there a way to associate the worksheet named "WorkSheet" with the Exceptions worksheet object?
Code:
Code:
Private mySheet As Worksheet
Code:
Code:
Set mySheet = Sheets.Add
mySheet.Activate
ActiveSheet.name = "WorkSheet"