Excel Macro - Pastespcecial problem

[madhumlr]

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.

 

[losmac]

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")