View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angela T Angela T is offline
external usenet poster
 
Posts: 1
Default Auto Fill Down Macro

Is there a macro that I can setup to auto fill down? For example I have an
Excel file that has numbers or text in column A rows 1, 5, 10, 17, etc. I
want to auto fill down whatever is in the cell above, only to the next
un-empty cell. So A1 auto fills down thru A2-A4 then A5 atuo fills down thru
A6-A9 and so on.