ExcelBanter - Printing worksheets from a list

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Printing worksheets from a list (https://www.excelbanter.com/excel-discussion-misc-queries/267005-printing-worksheets-list.html)

Paul S

Printing worksheets from a list

I am using excel 2000

I have a list of all the worksheets in column A and in column B data from a cell on each worksheet

Is it possible to select just the worksheets where the value in column B is greater than 0, so I can print just those worksheets

Thx

Paul

I have solved this with code that hides the sheets I don't want to print

Thx for looking

All times are GMT +1. The time now is 07:50 AM.