how to print cells based on "Yes".
 

If the first cell in row 1 of Column "A" is "Yes", how do I get preselected
contiguous or non contiguous cells in the same row to print? If the answer is
"no", I do not want cells in that row to print.


Thanks for anyones help!

Francis Knight

how to print cells based on "Yes".
 

Hi Francis

You can use DataAutoFilter to filter on that column and print.
Only the visible cells will print

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Francis Knight" <Francis wrote in message
...
If the first cell in row 1 of Column "A" is "Yes", how do I get preselected
contiguous or non contiguous cells in the same row to print? If the answer is
"no", I do not want cells in that row to print.


Thanks for anyones help!

Francis Knight

how to print cells based on "Yes".
 

check out the conditional formatting