Hi Carim, Thank you for your prompt reply.
I assume by attaching the sample sheet, I'm clarifying the aspect of the needs already, however, let me elaborate by answering your validating points:
1. ' active row ' - second cell means Column B ... but your sheet will ONLY have one row ... so why have you prepared 427 rows ?
Because each time the sheet will be re-opened, another row will be used and it will be the active row in this case.
2. ' active row ' - seventh cell ... do you mean Column G ?
Yes, I do
3. prevent deletion of the last row ... why only the last row ? is there a difference between ' active row ' and ' last row ' ?
I meant the active row, yes, I'm sorry.
P.S. Your title says ' Print ' ... do you really mean Print ... or do you mean Input ...?
I meant input, yes, I'm sorry.
If you've a different solution suggestions than the presented, they're truly welcomed.