Have a macro change the font to white for the row you dont want to see.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Demetrios13" wrote:

Hi, I would be very thankfull if anybody could help me with the following:

This is a simulation problem. According to a random generated number (using
the RAND() and the nested IF functions) the number of customers can be 10,
14, 18, 22.
I have a single worksheet of 22 customers (cell D4:D25). If # of customers
generated (in cell C4) is 10 how can I make it display only the first 10 rows
(customer 1 to 10 , D4:D13) and the remaining rows (11-22, D14:D25) to be
displayed as blanks. same goes for 14, 18 and 22 customers.

Thank you