johnsuncha
New Member
- Joined
- Apr 28, 2010
- Messages
- 2
<TABLE cellSpacing=0 cellPadding=2 width="100%" border=0><TBODY><TR><TD align=left>I am trying to write a macro to paste a row of data on to a row based on the row number desinated by the value of a pointer cell.
e.g. pointer cell "a1" value is 20 so paste in row 20.
Selection.Copy
Sheets("DB").Select
Rows("4:4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Thank you,
-jcha
</TD></TR></TBODY></TABLE>
e.g. pointer cell "a1" value is 20 so paste in row 20.
Selection.Copy
Sheets("DB").Select
Rows("4:4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
Thank you,
-jcha
</TD></TR></TBODY></TABLE>