Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004
I have a sub on a worksheet calculate area and the sub has these 4 lines:
Sheets("Results").Select Set Rng = Range("nonvalidreport") ActiveSheet.PageSetup.PrintArea = Rng.Address ActiveWindow.SelectedSheets.PrintPreview The sub is not on this sheet. But I get an error 1004 on line 2. If I run these 4 lines in a module it works, but I can't figure out how to call a sub in a module from the area where I am. HELP! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Error 1004, Application-definded or object-defined error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |