VBA macro in Excel

  • Thread starter Thread starter A Pretorius
  • Start date Start date
A

A Pretorius

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.
 
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
 
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
 
Back
Top