experts please

Im taking a new approach to my original question, is there a way to write a code that will add teh next consecutive date in the column next to the date if that cell is empty. In other words, if there is a date in cell in A3 (say April)and just some text in cell A4, then if I insert a column, I want to hit the macro button and fill in may in the cell next to April. Does that make sense? I think I need an IF statement to go along with:

Selection.AutoFill Destination:=Range("AA27:AB27"), Type:=xlFillDefault

I dont want it to always use the same cell, so I know this code isnt correct.

Please Help



Please post Excel questions, in the Excel forum.

Thank you.