| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro can't form a Range on an inactive Worksheet
You're right, here's the code:
Dim rNewRange As Range Set rNewRange = ActiveWorkbook.Sheets(sInSheet). _ Range(Cells(1, 2), Cells(5, 6)) Set rNewRange = ActiveWorkbook.Sheets(sOutSheet). _ Range(Cells(1, 2), Cells(5, 6)) One or the other works depending on what worksheet I'm starting the macro from. It gives a 1004, "appl-def'd or obj-def'd error". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I email an inactive copy of a worksheet | Excel Discussion (Misc queries) | |||
| shortcut key for selecting the inactive cells surrounding a range | Excel Worksheet Functions | |||
| macro to change data in inactive sheet | Excel Discussion (Misc queries) | |||
| macro can't form a Range on an inactive Worksheet | Excel Programming | |||
| How to get the activecell of inactive worksheet ? | Excel Programming | |||
![Peter Chatterton[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
