How do you determine where to store the data on that second sheet, which
row? Could you not just add a test in there to see if the row has reached
that number?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Ainsworth"
<Mike.Ainsworth.1u7rub_1124795118.8326@excelforu m-nospam.com wrote in
message news:Mike.Ainsworth.1u7rub_1124795118.8326@excelfo rum-nospam.com...

Hi,

I have a workbook containing two sheets. The first sheet has a User
Form that enters the data onto a second data sheet which is hidden. How
can I alert the user when the second hidden data sheet has data that has
reached a certain row number?.


--
Mike Ainsworth
------------------------------------------------------------------------
Mike Ainsworth's Profile:
http://www.excelforum.com/member.php...o&userid=26501
View this thread: http://www.excelforum.com/showthread...hreadid=398100