ExcelBanter - Print visible rows only

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Print visible rows only (https://www.excelbanter.com/excel-programming/382153-print-visible-rows-only.html)

AOU

Print visible rows only

Is there a way to print which ever visible rows I have on the screen?
--
AOU

Susan

Print visible rows only

if you search the newsgroup for

print visible rows

you will come up with lots of helpful code & suggestions.
:)
susan

On Jan 29, 11:43 am, AOU wrote:
Is there a way to print which ever visible rows I have on the screen?
--
AOU

Tom Ogilvy

Print visible rows only

Activesheet.Printout

or an alternate interpretation of your question.

ActiveWindow.VisibleRange.Printout

--
regards,
Tom Ogilvy

"AOU" wrote:

Is there a way to print which ever visible rows I have on the screen?
--
AOU

AOU

Print visible rows only

That works fine. Thanks very much
--
AOU

"Tom Ogilvy" wrote:

Activesheet.Printout

or an alternate interpretation of your question.

ActiveWindow.VisibleRange.Printout

--
regards,
Tom Ogilvy

"AOU" wrote:

Is there a way to print which ever visible rows I have on the screen?
--
AOU

All times are GMT +1. The time now is 01:25 PM.