copy paste

N

nowfal

Hi,
I have a copy paste code in one of my macro. I wanted to control the
copy paste as only data. At present this is copying any blank cell or
formula, that effect my sumproduct result as #value. below shown is
the code :

Range("A2:AH10000").Select
Selection.Copy
Range("A3").Select
ActiveSheet.PasteSpecial Format:=3, Link:=1, DisplayAsIcon:=True,
_
IconFileName:=False

So I wanted to be copy and paste only data in A2:AH10000 to be copied
to down.
Any idea will be helpful to me.
thanx
regards
NOWFAL
 
H

Henry

Nowfal,

Range("A2:AH10000").Copy Destination:=Range("A3")

should do what you want.

Henry
 
Top