Automatically set current active worksheet to myWorksheet

[ljCharlie]

Is there a way to automatically detect the worksheet name of a workbook? Here's what I want to do.

Dim myWorksheet As Worksheet

Now, I want to Set myWorksheet to the currently active worksheet. How do I do this?

Help is appreciated.

ljCharlie

 

[PHV]

What about this ?
Set myWorksheet = ActiveWorksheet

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ljCharlie]

Thanks but that doesn't work. I got an error saying variable not defined on the word "ActiveWorkSheet"

ljCharlie

 

[ljCharlie]

Thanks! I found it. It's ActiveSheet and not ActiveWorkSheet.

ljCharlie

 

[PHV]

Sorry for the typo:
Set myWorksheet = ActiveSheet

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244