What do you currently have in code or as a worksheet formula.
Is there anything in Column A that is not to be included?
What kind of count, if you included the answer to the first question
this would have been obvious.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Michael168" wrote in message ...
May I ask for advice on how to auto update sheet2?
That is I have my data in sheet1. My answer in sheet2.
In sheet2 cell A1 I have the count value of sheet1 range A1:A1875.
So when I add new row of data in sheet1 the new range will be
A1:A1876.
How can I make Cell A1 in sheet2 auto update the count to A1:A1876
instead of manually changing the range everytime I make an update of
rows in sheet A1.
Thank you for your advice and sorry for the troubles caused.
With Regards
Michael168
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/