Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macro in Excel
I need an explanation of an error message "Run-time error '-2147319784
(80028018)': method of 'Activate' of object '_Workbook' failed". Basically, this is an Excel file with VBA macros that will not run. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macro in Excel
Hi
The error messages in themselves are often not very useful. Better to show us the code and which line is highlighted when the error occurs. regards Paul On Jan 9, 9:38*am, A Pretorius wrote: I need an explanation of an error message "Run-time error '-2147319784 (80028018)': *method of 'Activate' of object '_Workbook' failed". *Basically, this is an Excel file with VBA macros that will not run. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA macro in Excel
The row with the arrow is the selected text.
Range("A9:A16").Select Selection.RowHeight = 30 ---ActiveSheet.DrawingObjects("Dropdown 34").Select Selection.Height = 27 Range("A17:B17").Select Selection.RowHeight = 100 The problem is the error message varies with which machine one uses. This is the selected text from my machine. Thanks " wrote: Hi The error messages in themselves are often not very useful. Better to show us the code and which line is highlighted when the error occurs. regards Paul On Jan 9, 9:38 am, A Pretorius wrote: I need an explanation of an error message "Run-time error '-2147319784 (80028018)': method of 'Activate' of object '_Workbook' failed". Basically, this is an Excel file with VBA macros that will not run. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Call macro stored in Excel workbook from Outlook's macro | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming |