Possilby use the change event for sheet2

http://www.cpearson.com/excel/events.htm

for an overview of events.

--
Regards,
Tom Ogilvy


"Sukh" wrote:

Dear All,

I have a Macro that tells the user the number of rows that contain data in a
spreadsheet. I would like the macro to automatically run anytime a new row
of data is added within a certain sheet, i.e. Sheet2, how would i do this?

Thanks in advance