| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
looping through worksheets
Tom, Thank you very much for suggestion. I tried it and it still did not work. Thanks, Alex *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
looping through worksheets
Error 9 is subscript out of range.
Set cell = Workbooks("0620.Xls").Sheets("d.o.").Range Set update = Workbooks("0620.Xls").Sheets(b).Range("d26") choices are no workbook namd 0620.xls no sheet name d.o. no sheet with the name in variable b Regards, Tom Ogilvy Alex ekster wrote in message ... Tom, Thank you very much for suggestion. I tried it and it still did not work. Thanks, Alex *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Looping Macros | Excel Worksheet Functions | |||
| Looping | Excel Discussion (Misc queries) | |||
| Not Looping | Excel Discussion (Misc queries) | |||
| Looping | Excel Discussion (Misc queries) | |||
| looping through worksheets | Excel Programming | |||
Linear Mode
