Help with Macro. -- User input for sheet name
Hi Michael,
Additionally, change:
estuff.Activate
to Sheets(estuff).Activate
---
Regards,
Norman
"Michael A" wrote in message
...
Hi Norman,
I have tried that as well. I get the error
"invalid qualifer" on line : estuff.Activate
Im trying to activate that sheet.. im stuck. Any other suggestions? And
thanks for the response.
- Mike
"Norman Jones" wrote:
Hi Michael,
Try changing:
Dim estuff As Worksheet
to
Dim estuff As String
---
Regards,
Norman
|