| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
9: Subscript out of range
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
| Run Time Error 9 (Subscript out of Range) for XLA file | Excel Discussion (Misc queries) | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
