"Syr Doug" wrote in message
...
Thanks for the reply, not quite. I know about Active Cell. I need more
the current row

This will be pretty much static.

Cell A1 = I will need the data value of the AD + currentrow
Cell B1 = I will need the data value of the AE + currentrow
Cell A2 = I will need the data value o fhte AF + currentrow


you mean something like ActiveCell.Row so maybe
[A1].Value = Cells(ActiveCell.Row, 30) '30 is column AD
[B1].Value = Cells(ActiveCell.Row, 31) '30 is column AE
[A2].Value = Cells(ActiveCell.Row, 31) '30 is column AF

Paul D