Printing value only cells

[Ify]

Please I have two queries:

1)I will like to be able to print out or printview only the cells o
on my worksheet that contain currency values other than 0s an
depending on the specified range without highlighting the range.

2) Is there any way by which I can copy from a sheet and paste ont
different sheets in the same workbook at the same time.

Thank you for helping out on my last query for the count betwee
values

 

[Frank Kabel]

Hi
1. See: http://www.rondebruin.nl/print.htm#Hide

2. Try selecting all sheets while holding down the SHIFT key (grouping
the sheets). then paste the contents