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.

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.

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.