How to Print taking input & changing other dependent cell values accordingly?

In my "Attend" sheet, it contains a formula. If the value in cell A1 changes from 1 to 50000, then other dependent cells get changed accordingly. I need a VBA code for excel that will ask for a range of numbers to enter into cell "Attend!A1" and will print the page (e.g. Attend!A1:G33), changing other dependent cell values accordingly.
For instance, for first value of given range, it will changes other dependent cell values and print first page, then from the given range it will print second page changing other dependent cell values accordingly. Thus changing other dependent values for other pages taken from input range successively.

I found following code online that works fine, but it creates a hundred different files for 1-100 (one hundred) inputs and sends them to the printer, which causing the device to slow down or hang.
Is it possible to send all the updates of the input to the printer in one file (or print preview) or can the update of all the data of the input be PDF together with any VBA code?
I will be grateful if anyone can help me.

Please Login or Register  to view this content.

No formulas on the Attend sheet row four.

Please Login or Register  to view this content.

First off, I apologize for the delayed response. I was a bit busy.

However, I am very honored to see that a "forum guru" has come forward to solve the problem of a common member like me.

The code you provided solved my problem to the desired extent. I thought it might not be possible to solve it in VBA code; we have to take help from 'MS Access'. The reality is that you have finished this challenging work using VBA code.

I feel embarrassed to ask for more help after all the time and effort you have put into helping me.
If you ever free, notice that when the code is run and no input is given, it shows error code '9," (Subscript out of range). Also, it would have been nice to see a 'No input given' message.

Also, instead of sending the file to the printer, I would have benefited from having the code to PDF the output data in the same folder.

Also, what would the code look like if I kept the 'Attend' sheet hidden?

I appreciate you taking the time to decipher my lengthy and complicated code.
Thanks once again.

• it would have been nice to see a 'No input given' message (ok)
• PDF the output (ok)
• You can't copy hidden sheet.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

When I ran the given code, the compiler didn't show any 'errors'. The desired and accurate output is obtained in one go.

However, When a person's expectations and wishes are met, it is only possible to interpret his or her level of happiness by looking at their "facial expression." Looking at the tiny wording won't help you grasp my delight or my current mood. If you saw me, you could understand how good I feel. I am very very grateful to you.
Prayer: May God bless your talent and work. God bless you.