Report

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: http://ccm.net/faq/27361-excel-a-macro-to-create-and-name-worksheets-based-on-a-list#solution

thanks
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!