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

I've seen that message occur when a program expects a number to be
within a certain range but the number is outside that range because of
user inputs or something. Do you mind posting the code? It will be
easier to troubleshoot.

Subscript out of range will mean that your code is looking for something that
doesn't belong to that collection.

For instance, if you have code that looks like:

dim wks as worksheet
set wks = worksheets("sheet1")

If you don't have a worksheet named Sheet1, then you'll get this error. It
could be a simple misspelling or something worse.



jenz21985 wrote:

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

--

Dave Peterson

Not sure where to find the code

Can you point me in the direction

Thanks


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

"jenz21985" wrote
in message ...

Not sure where to find the code

Can you point me in the direction

Try:
Tools/ Macro/ Macros ...
--
David Biddulph

Right-click on the Month/Year button, click Assign Macro, click Edit.
The VBA editor will appear, and the code associated with the Month/Year
button will be showing: please copy everything from the word Sub to the
words End Sub (inclusive), and post it. Review it first, of course, to
make sure it does not somehow divulge sensitive information.

When I click on tools, maro, macros it just comes up with an empty box
asking me to type in the macro name.

I cannot right click on the month/year button.

Any other suggestions




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