| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - IF command
I have a master report dragging blocks of data via a macro, from man individual order spreadsheets 001.xls, 002.xls etc. My problem is that I have to continually open the master report an take the ' out from infront of the macro line associated with ne orders in order to allow the macro to open the new order spreadshee and get the required data. Is there some way I can get the macro to ignore the line of code for a order number who's spreadsheet does not yet exist. Okane -- okane ----------------------------------------------------------------------- okanem's Profile: http://www.excelforum.com/member.php...nfo&userid=930 View this thread: http://www.excelforum.com/showthread.php?threadid=55821 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
| macro command | Excel Worksheet Functions | |||
| Macro Command | Excel Discussion (Misc queries) | |||
| Macro Command | Excel Programming | |||
| macro command | Excel Discussion (Misc queries) | |||
![okanem[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
