| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copy paste
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
| Copy and Paste and keep format the same | Excel Discussion (Misc queries) | |||
| Copy & Paste | Excel Discussion (Misc queries) | |||
Threaded Mode
