Question re a relative not absolute macro

[alun]

Hi

What I need to do is this on a macro

a) have excel change some numbers on this row
b) have excel change some numbers on the next row

when i've tried this it always changes the EXACT cell that i recorded it on.

in other words it acts absolutely not relatively.

So if I'm on row 12 I'll want it to alter F12 and D13, if i'm on row 18 I'll want it to alter F18 and D19.

Is this possible?

Many thanks

Al

 

[Von Pookie]

You can use ActiveCell.Row to refer to the row the cell is currently in:

Sub test()
Dim myRow As Long

myRow = ActiveCell.Row
Cells(myRow, "D").Value = "X"
Cells(myRow, "F").Value = "Y"

End Sub

 

[alun]

Cool many thanks Kristy!