Help on macro output

[Xerses/Antonio from Work]

Hi all,
with pain, blood and a friend I've written a simple macro, but, due
to my inexperience I can't position the output result where I want. The
string that place the output of the if loop is this one:

For i = 1 To 5

Worksheets("sheet2").Cells(65536, i).End(xlUp).Offset(1, 0).Value
= .Cells(l, i).Value

Next

The problem is that this string place the output from the A2 cell
placed in sheet2. If I'd like to place the output from A10 or let's say
F10 in sheet2, how I have to write the string?

Many thanks and kinds Regards

 

[John]

Hi,

I'm having trouble understanding what you are trying to do. Are you trying
to set values in the top row to equal those in the bottom row?

Regards

John

 

[JE McGimpsey]

If I understand you correctly:

For i = 1 to 5
Worksheets("Sheet2").Cells(10, 5 + i).Value = .Cells(l, i).Value
Next i