On Sep 4, 1:00*pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
what's the text of the 1004 error?

--

Gary

wrote in message

...
On Sep 4, 12:29 pm, Gary''s Student





wrote:
Your code works. Make sure the tab names are spelled correctly.
--
Gary''s Student - gsnu200802

" wrote:
Hi,

I have a weird problem. I've created a workbook that dozens of sales
people use. One laptop, which is the exact same configuration as all
of the others, is having a problem running my code.

With Sheets("Order")
.Range("A2:V200").Delete

Sheets("OrderPrep").Range("B3:U29").Copy
.Range("B1").PasteSpecial xlPasteValues
.Range("B1").PasteSpecial xlPasteFormats
End With

It's not this specific piece of code; it happens with EVERY
pastespecial that this laptop runs. I can't figure it out!

any suggestions?

thx- Hide quoted text -

- Show quoted text -

It's nothign wrong with the workbook, it's gotta be a setting
somewhere. *It works fine on 11 other computers.- Hide quoted text -

- Show quoted text -

"Error #1004: Merged Cells must be identically sized"