Hi!

i can have any number of rows in Sheet 1. There are four cols in the data: A,B,C and D.

1) First, i want to find out how many data rows exist. Please note, i do not want to use UsedRange, as it is misleading.

2) Second, there is a date function in D1. I want to autofill this function in all the rows that contain data.

how shud i do this?
Thanks for ur help!

regards
ashu

 1. put this in your code
Lastrow = Sheet1.Cells.Find("*", Range("A1"), xlFormulas, , _
             xlByRows, xlPrevious).Row

2. Do you want the same date in all cells? Or do you want to fill the actual
date in the last row when you add more data?
Cheers
Karsten

thanks for ur response. My prob has been solved. :)