Runtime Error '1004'

T

TAS9981

If anyone could help, I would appreciate it.

I have a spreadsheet with a few macros and some VB code in it.
Everytime i click "Save As" to update my changes and save as a ne
version, I get the following error :

Runtime error '1004'
Activate method of range class failed.

But if I just hit END, it saves and that's that.
What can I do to get rid of the error?

Thanks,
 
J

Jim Rech

Sounds as if a "Workbook_BeforeClose" macro is running in this workbook.
Maybe it should be repaired or deleted. To see it, right-click the workbook
icon in the top-left corner of the workbook window (or to the left of the
File menu if the workbook window is maximized) and click View Code.
 

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 inserting rows (and cutting) 2
Runtime error 1004 2
Runtime Error 1004 5
Why do I get VLookup error 1004 2
What causes runtime error 1004? 4
Runtime Error '1004' 2
Unhide 2
Runtime Error 1004 Unable to set the top property of the picture c 1

Top