0 votes
ago in VBA by Beginner (15 points)
edited ago by

Hi guys

How would I get the following to work? I have a list and was hoping to check if a worksheet name has a match in Column A of the list and get the corresponding in B.

At the moment, all I can think of is doing it name by name.

Sheets("One").Name = "OneNewOne"

Only issue is it might get rather long and I might miss something. Can someone please help?

Much appreciated!

Please log in or register to answer this question.

Welcome to wellsr Q&A
Ask any questions you have about VBA and Python and our community will help answer them. wellsr Q&A is the standalone question and answer platform for wellsr.com. If you have a question about one of our specific tutorials, please include a link back to the tutorial.

Getting Started
VBA Cheat Sheets (On Sale Now)

Looking for something else? Hire our team directly through ourVBA Help page, instead.

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.