| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prob. running macro from diff. sheet
I have this line in my macro:
Worksheets("ABC").Columns("A:A").Select If I run this macro when I am in a different sheet, it gives the run-time error 1004. How can I avoid this? What is the reason? Thx in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
prob. running macro from diff. sheet
sorry, the answer is activating the sheet before that line:
Sheets("ABC").Activate i did the search but with "sheeeet" in the search-box, sorry :) "darxoul" wrote: I have this line in my macro: Worksheets("ABC").Columns("A:A").Select If I run this macro when I am in a different sheet, it gives the run-time error 1004. How can I avoid this? What is the reason? Thx in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing Check Boxes & Running a diff Macro when unchecking the ch | Excel Discussion (Misc queries) | |||
| Find based on cond. 4matting? Replace as ALT-Enter? (2 diff prob | Excel Discussion (Misc queries) | |||
| Don't show sheet switches when running macro | Excel Programming | |||
| Running Macro on every sheet in Workbook !!! | Excel Programming | |||
| excel simple prob w/running subtotals | Excel Programming | |||
Linear Mode
