| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy to datasheet -Message for Ron De Bruin
I an using your copy next each other sub and last row function.
My question is there a maximum number of ranges that can be used within the Set sourceRange = Sheets("Sheet1").Range statement. I have 41 ranges which works fine but as soon as i add further ranges i get a run time error 1004. If there is a maximum is there away to increase it. Thanks in anticipation Tredown |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Datasheet with drop down | Excel Discussion (Misc queries) | |||
| Copy a Range from each workbook - Ron de Bruin VBA - a problem | Excel Worksheet Functions | |||
| Ron de Bruin - Using PasteSpecial (xlPasteValues) instead of Copy | Excel Programming | |||
| PowerPoint datasheet | Excel Programming | |||
| Message for Ron de Bruin | Excel Programming | |||
Threaded Mode
