Hi Aidan,

Try something like:

rCell.Value = rCell.Offset(-1,0).Value


---
Regards,
Norman



"afmullane" wrote
in message ...

Hi guys,

I want to be able to implement an auto number function. So i'm trying
to read in the value of the previous row of the column. I'm using:

Cells(target.row, 2)

to find to find the row but i want to be able to read the value of the
number in the cell so that i can add 1 to the number.

Any help would be greatly appreciated,

Aidan


--
afmullane
------------------------------------------------------------------------
afmullane's Profile:
http://www.excelforum.com/member.php...o&userid=33567
View this thread: http://www.excelforum.com/showthread...hreadid=538420