Hi
i am looking for coding that renames the current active sheet and the following 4 worksheets with new names based on cell values within each worksheet cells "BA1"
thanks
Danny
Hi
i am looking for coding that renames the current active sheet and the following 4 worksheets with new names based on cell values within each worksheet cells "BA1"
thanks
Danny
Hi, you could use a worksheet activate event. for each of the four worksheets, just copy this code to the worksheet project
What this does is when the sheets is selected (activated) it checks if the worksheet's name is the same as the value in BA1 and if that cell is not empty, then it just renames the worksheetPlease Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hi
Thanks for the advice, but unfortunately that idea interferes with the original code. The original code basically duplicates 5 worksheets and moves to the end of the workbook. i basically need the new 5 worksheet to have a new name without effecting the original sheets.
The way to go is to name the sheets when you copy them.Please Login or Register to view this content.
A quick example.
Please Login or Register to view this content.
Last edited by jolivanes; 12-23-2021 at 11:48 PM.
If you are using this code to create copy of the worksheet Sheet1
then usePlease Login or Register to view this content.
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Hi Keebellah,
thanks for your help and yes you did answer to the information i initially gave you. Next time i'll try to be clearer.
That's great thanks Jolivanes
Great, happy coding in 2022, keep safe
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks