Macro Doesn't Work With Command Button

I need a macro that will copy Range A5:B65536 on sheet1 (Sheet name - "Seller Info") and copy to sheet 2 (Sheet Name - "Totals"). See code below. When I run this as a macro in Module 1, it runs flawlessly. I want to run this macro through a command button. It does not give me the run time error... it just wont copy and paste. I put the code that is not working in bold font.

Thanks in Advance

jbmerrel

Please Login or Register  to view this content.

Hi,

Can't see any Bold font.
Almost impossible to diagnose without seeing the problem in context. Why don't you upload the workbook so that we can take a look.

One thought. Is this a .xls file where the last row is 65536? If so if you are copying A5:B65536 and the .End(xlup) takes you to a row below row 5 on the totals sheet then Excel will presumably complain since there's no room to paste 65532 rows.

Are you sure you really do want to be copying nigh on the max. number of rows?

Regards

So which sheet is the active sheet at the start of your posted code?

Your code switches off screen updating without restoring it - not a good idea.

This is a guess at what you want

Please Login or Register  to view this content.

See also - How to add a button

http://excel-it.com/add_button.htm