Select the range, press F5, select special and visible cells only, copy and
paste

Regards,

Peo Sjoblom

"darlinvee" wrote:

Not including selecting each one individually.