<div>
a bit hard to start without example...<br />
is this a worksheet tab or a form ?<br />
<br />
can you start the macro recorder, print the 'tab' manually, then stop the macro recorder. &nbsp;Please Post the resulting code.<br />
(macro recorder is on developer tab that you have to enable in Options)
</div>


a bit hard to start without example...
is this a worksheet tab or a form ?

can you start the macro recorder, print the 'tab' manually, then stop the macro recorder.  Please Post the resulting code.
(macro recorder is on developer tab that you have to enable in Options)

<div>
<div class="content wysiwyg-content">
Hi Team,<br />
I have design a dashboard like worksheet Tab. Here I have many fields ike dropdown, textbox and comment field. out of these only comment field is dynamic i.e. its size does change automatically as input goes.<br />
I need a print functionality so that I could print this. <br />
Can you please suggest how could I print this dynamic Tab using VBA.<br />
Also require if print goes beyond one page because of long input comments I might require footer as well.<br />
Looking forward to hearing from you.
</div>
</div>


Hi Team,
I have design a dashboard like worksheet Tab. Here I have many fields ike dropdown, textbox and comment field. out of these only comment field is dynamic i.e. its size does change automatically as input goes.
I need a print functionality so that I could print this. 
Can you please suggest how could I print this dynamic Tab using VBA.
Also require if print goes beyond one page because of long input comments I might require footer as well.
Looking forward to hearing from you.

Printing Active Worksheet using VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.