In need of VBA that copies a range and pastes on new worksheet in the workbook

[daltendavis]

I am in need of a VBA macro I can apply to a button to copy range E2:O100 and R2:AJ100 on work sheet titled "Historical Orders" to its own new worksheet beginning at cell A2. The new worksheet can have sheet1/2/3/etc. as a name that does not matter.

This process will be repeated every few months so multiple new work sheets will be created if that raises any problems. Thanks in advance for any and all help.

 

[Fluff]

I cannot replicate that error.
Do you have any merged cells, or sheet protection?

 

[daltendavis]

I did have merged cells, and had frozen some cells, however I removed both and still no dice

 

[Fluff]

In that case I'm not sure why it's not working for you.

 

[daltendavis]

Dang Ive checked spelling, everything I can think of..... I found a similar code that had a .paste function in it but it does not work for my project. Im stuck