Hi... is there any way I can determine the number of rows used using formula instead of macro?...

The number of rows would constantly be increasing...