Excel Macro - Pastespcecial problem

M

madhumlr

Joined
Aug 21, 2008
Messages
1
Reaction score
0
Hi Frnz,
I have a problem. Whenever i use pastespecial method, data will be pasted as picture.
i have used the fillowing statement to copy the data
InvSheet.range("A1:M5").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

where InvSheet is the sheet object of Sheet1

Please let me know how to solve this.
 
Hello,

Can you show me how you create object of Sheet1 named as InvSheet?
What kind of data are you trying to copy?

Try the other method:
OtherSheet.Range("A1:M5").Copy InvSheet.Range("A1")
 
Back
Top