I amy trying to copy the current value of a row from one worksheet (Data
validated list) to another worksheet. The first time the destination is
"A50", the second time has to be "A51" so as not to overwrite previous copy.
In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I
cant figure out how to use the value in I12 to advance the destination from
A50 plus that value.

GeekRN,

Try this as your copy destination:

Range("A" & 50 + Range("I12").Value)



--
Hope that helps.

Vergel Adriano


"GeekRN" wrote:

I amy trying to copy the current value of a row from one worksheet (Data
validated list) to another worksheet. The first time the destination is
"A50", the second time has to be "A51" so as not to overwrite previous copy.
In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I
cant figure out how to use the value in I12 to advance the destination from
A50 plus that value.

Dim myDest As Range
Set myDest = Worksheets("Sheet2 Name").Range("A50").Offset(Worksheets("Sheet2
Name").Range("I12").Value,0)
Worksheets("Sheet2 Name").Range("whatever").Copy myDest

HTH,
Bernie
MS Excel MVP


"GeekRN" wrote in message
...
I amy trying to copy the current value of a row from one worksheet (Data
validated list) to another worksheet. The first time the destination is
"A50", the second time has to be "A51" so as not to overwrite previous copy.
In cell I12 is the selected sequence number to assist (1,2,3,4,5...)but I
cant figure out how to use the value in I12 to advance the destination from
A50 plus that value.