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.