| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference problem
Jesmin, Are there macros or other VB code recorded in your original that might be causing the problem? Was the error "Run-time error '9': Subscript out of range" If you have code in the original book that was recorded using the original sheet names (i.e. Sheet!1), you'll have to update the code with the new sheet names. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=508212 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to reference a value in a cells for a row number | Excel Worksheet Functions | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| a cell reference in a 3d reference | Excel Worksheet Functions | |||
| Returning with cell on right/left of a reference | Excel Worksheet Functions | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Threaded Mode
