K Ken Wright Jan 29, 2004 #2 Select range, do Edit / Go To / Special / Visible cells only / - Then Copy and paste.