Filter, clearing visible cells in a range, but leaving hidden cells

[Jason Chapman]

Hi,

I have a filtered worksheet. I want to be able to select a range and
clear the contents OR paste into the visible cells. Trouble is it
clears all of the cells in the range, visible or invisible.

Is there a way round this?

TIA

 

[Ron de Bruin]

Hi Jason

After you select the range use
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.

 

[Jason Chapman]

After you select the range use
Alt ; or F5>Special>Visible cells only>OK to select only the Visible
cells.

AMAZING - thank you, that will save me ages. Works a treat.