runtime error 1004 pastespecial method of range class failed


D

dreamz

a vba-excel-based application i created for a client has been suffering
from a bug, the runtime 1004 error.

i can't figure out what the problem is, as i've tried it on two
different computers and i can't reproduce it on either of them.


Code:
--------------------

shOppFit.Range(Range("Y4:Z4"), Range("Y4:Z4").End(xlDown)).Copy
With shTemp
.Activate
.Range("Q1").PasteSpecial Paste:=xlPasteValuesAndNumberFormats
End With
 
Ad

Advertisements

D

Dave Peterson

Is it this line
shOppFit.Range(Range("Y4:Z4"), Range("Y4:Z4").End(xlDown)).Copy

if Yes, try fully qualifying those ranges:

with shOppFit
.Range(.Range("Y4:Z4"), .Range("Y4:Z4").End(xlDown)).Copy
end with

The dots in front of the .ranges mean that that thing belongs to the object in
the previous with statement.

Without fully qualifying those ranges, those ranges will refer to the
activesheet (or the worksheet that holds the code--if you're in a worksheet
module).
 
D

Dave Peterson

Oops on the .pastespecial line....

Are you using the same version of excel?

xlpastevaluesandnumberformats was added in a newer version. Your client may not
have that newer version.

(maybe do two pastespecials values, then formats??)
 
Ad

Advertisements

D

dreamz

thanks for the replies, everyone.

1. sheets are protected, but get unprotected before getting written.
2. shtemp exists.

this application works on my computer and on another one my office, bu
it doesn't work on the client's computer.

dave, you may be onto something. i talked to the client yesterday, an
found out he's using win2k. i coded this application in excel 2003, bu
he is probably using an older version
 
Ad

Advertisements


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

Top