| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active Workbook
I think I did... The actual error says "subscript out of range..erro 9". both workbooks have several worksheets, one over 90 and the other on over 30. When the macro worked, it would (using another sub I have match the ws names on both and copy the cell ranges from one to th other, then go to the next matching set of ws and do the same until i copied all specified cell ranges from all ws. it baffles me that it actually worked for a few weeks and it jus stopped working. No one else has access to it and it is passworded -- halem ----------------------------------------------------------------------- halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993 View this thread: http://www.excelforum.com/showthread.php?threadid=55013 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Closing Hidden Workbook when Active Workbook is Closed | Excel Programming | |||
| copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
| How do I make an open workbook the active workbook | Excel Programming | |||
| Copy Modules from One workbook to Active Workbook | Excel Programming | |||
| Preventing opening workbook inside active workbook. | Excel Programming | |||
![halem2[_70_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
