error msg 400

[hschussler]

I am trying to copy a sheet onto another wprkbook (which has macros) and after I copy and try to compute the macro I get an error 400 msg...what should I do?

thanks,

 

[xenou]

Unfortunately Error 400 doesn't tell you much except that something isn't working.

Make sure your macro references the correct sheet names and workbooks...a sheet must be active to make changes to it in code, and also the sheet must be in the active workbook to make changes to it in code.

Otherwise, step through the code until you can find where the error occurs.

Debugging help:
http://krgreenlee.blogspot.com/2006/04/programming-excel-vba-debugging-for.html

http://www.cpearson.com/excel/Debug.htm

 

[ExcelChampion]

what should I do?

You can start by posting the code you are using.