Current WorkSheet name VBA

**rtcwlomax** · 06-16-2015, 06:49 AM

Hi All,

I have a Command button that shows/hides rows in a WS. I want to be able to copy the WS and rename it so need the script on my Command Button to get the name of the active sheet.

The following code gives me runtime error 9. Any suggestions why this might be?

Please Login or Register  to view this content.

**Norie** · 06-16-2015, 06:52 AM

Either remove the quotes around wsName or just use ActiveSheet.

Please Login or Register  to view this content.

**rtcwlomax** · 06-16-2015, 06:54 AM

Thanks Norie,

I posted this at same time as you replied to my original query.

I just noticed also that if a copy and paste into a new sheet my Cmd button disappear!? Not to worry I think I have found the answer in another thread.