Find the value of a cell

[afmullane]

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

[Norman Jones]

Hi Aidan,

Try something like:

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


---
Regards,
Norman



"afmullane" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>