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


--
nowfal
------------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=401609

Nowfal,

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

should do what you want.

Henry


"nowfal" wrote in
message ...

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


--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread: http://www.excelforum.com/showthread...hreadid=401609