Select row based on pointer cell

[johnsuncha]

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

 

[Joe4]

Welcome to the Board!

Is the "pointer" cell on the same sheet you are pasting to?
No matter, you can "capture" the value before your select your range to copy in a variable, i.e.

Dim myRow as Long
myRow=Range("A1").Value

Then when you are the sheet you want to past to, you can use that variable, i.e.

Rows(myRow).Select

 

[johnsuncha]

Works perfectly
thanks a bunch