VBA macro in Excel

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.
 
P

paul.robinson

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
 
A

A Pretorius

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
Save failing 2

Top