Multiple sheet rename in VBA

Ask a question REGGIENEO 1Posts Sunday August 13, 2017Registration date August 13, 2017 Last seen
Hi All,
I see this post and somewhat similar to what I would like to achieve. but it gives me a "Run-time error '9: subscript our range".

I made sure that all the ranges and cells is in the same workbook.

please see link:

See more 

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!