Dynamic VBA solution for sheet name

[Yash1994]

I have one query as i am running below set of do while VBA code and getting error as code is not able to find exact sheet name as "New Consolidated Forecast " (which have space at last in the sheet name).
Also some of the excel templates have sheet name as "New Consolidated Forecast" (without space).
So is there any way to do the compilation as dynamic no matter that particular sheet name have space or not.

VBA Code Screenshot:

ErrorImage:

Thanks for you help in advance

 

[Marc L]

As 'dynamic' is a non existing Excel word ! As a reminder a true template has fixed things, nothing changes !​

Did you try with the worksheet CodeName ?​

Anyway you must first check the codeline raising the error​

which is the missing important information from your initial post, as guessing can't be helping …​

​

 

[Yash1994]

is there any code or something to do with that?

 

[Marc L]

With that what ?‼ As it is at beginner level to check worksheets names …​

And if the so called 'templates' are smart enough designed maybe you can use the worksheet CodeName rather than its name​

or if located always at the same position just with its index.​

​

 

[Marc L]

According to VBA help the classic way for badly designed workbook :​

​

​

​

Do you like it ? So thanks to click on bottom right Like !​

​