Wonder if any one can help.

I know very little about excell & macros & I have been given a
spreadsheet to update which just happens to be full of them.

At present I have one worksheet called MR600. In that I have a
Month/year button which i press & the whole spreadsheet updates with
new dates etc.

The thing is I need to have 30 of the same worksheets all with
different names but as soon as I rename the worksheet & try to click on
Month I get an error - 9: Subscript out of range.

Can anyone tell me what Im doing wrong or what & where & how I would
update it to work?

Thanks



--
jenz21985
------------------------------------------------------------------------
jenz21985's Profile: http://www.excelforum.com/member.php...o&userid=34109
View this thread: http://www.excelforum.com/showthread...hreadid=539228