I have a variable sized data set in a work sheet. Simplified it's like this:

A B
1 data1 =Today()
2 data2 =Today()
3 data3 =Today()

(Column A lists rows of data, Column B I want to insert today's date for each row)



I have a series of macros that reformat the worksheet dataset and I want to tack on the "Today's Date" formula for each record without going past the lastrow (of column A). The number of rows varies each time I import the record set. What I'm doing now is copying the formula (from Row 1) and pasting itinto a number of records I know exceeds the total of record rows imported. I then go back and delete those extra rows. (I do this for several other columns with different functions).

I know there is a better way.

Thanks.

Jeff

__________________
jm