Hi all,

I use the following formula to get an Auto Serial Number for all cell
in column A.


Code
-------------------
=IF(B2<"",ROW()-1,""
-------------------


My question is how can I get an Auto Serial Number for all cells i
column A by using VBA.

I hope that my quesion is clear,

Thank you

--
LoveCandl
-----------------------------------------------------------------------
LoveCandle's Profile: http://www.excelforum.com/member.php...fo&userid=2861
View this thread: http://www.excelforum.com/showthread.php?threadid=48756