Tab Name Matches Cell

[nahroster]

I found the below script on this forum for "How to get a tab name to match the data in cell C6". PROBLEM IS: for some reason, it is applying the Tab name to another worksheet instead of the selected worksheet into which I placed the code - it appears to be applying it to the First worksheet, instead of the selected worksheet. How do I tell it to apply the name to the worksheet in which I placed the code?

Please Login or Register  to view this content.

[rylo]

Hi

Firstly, can you please read the rules about wrapping code. I've edited your post for you this time, but please remember to wrap code in any future post.

Try using the activesheet.name approach.

Please Login or Register  to view this content.

rylo