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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem transferring Excel macros to another language 1
Excel run-time eror 1
Macros from German excel don't work with English version 3
Macro no longer works in XP 1
Run-time error -2147319784 (80028018) when executing a simple macr 3
Runtime error with sheets.add 2
SaveAS dialog box gives run time error 1004 in Excel VBA 3
Macro to Update links on a network 4

Back
Top