View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Hankin[_3_] Chris Hankin[_3_] is offline
external usenet poster
 
Posts: 20
Default AutoFill Help Please

Hello,

Could someone please help with the following Excel 2003 AutoFill
problem?

I am trying to create a macro so that when a new row of data is added to
my worksheet, the formula in column J is automatically AutoFilled down
to the last row of data. I only add one row of data at a time. So, I
am basically only AutoFilling down one row at a time.

The worksheet is named: SP155_Register

The is a header row at row 2

The data rows start at row 3

The cell at J2 is called: STATUS

If anyone can please help, it would be greatly appreciated.

Thanks,

Chris.

Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***