Hey, I am trying to create a macro that will automatically do a particular set of changes to the same workbook, that has multiple worksheets, every three months. I do not know much/really anything about VB unfortunately, so I just recorded the macro through excel.
It recorded fine and it has all the changes that I want it to make for my workbook, but I have a problem in that the my worksheet names also change every 3 months i.e., one will say 'December 2010 vs. Sep 2010' and in three months it'll change to 'March 2011 vs Dec. 2010.'
When I try and run this same macro (which i created when the worksheet was called 'Dec 2010 vs. Sep 2010') with the changed tab names I get an error because I guess it can't find that particular worksheet, even though all the changed was the name.
Is there anyway to code my macro so that it just goes to the generic Worksheet 2 instead of looking for 'Dec 2010 vs. Sep 2010'?
It recorded fine and it has all the changes that I want it to make for my workbook, but I have a problem in that the my worksheet names also change every 3 months i.e., one will say 'December 2010 vs. Sep 2010' and in three months it'll change to 'March 2011 vs Dec. 2010.'
When I try and run this same macro (which i created when the worksheet was called 'Dec 2010 vs. Sep 2010') with the changed tab names I get an error because I guess it can't find that particular worksheet, even though all the changed was the name.
Is there anyway to code my macro so that it just goes to the generic Worksheet 2 instead of looking for 'Dec 2010 vs. Sep 2010'?
Last edited:
