Select your range, then choose Edit/Goto/Special and select the Visible
cells only radio button. Copy and Paste.

In article ,
"Steve" wrote:

Is there a way to copy and paste several rows of information and formulas,
without pasting the hidden rows that lye in between?