pasting ranges, but not with hidden columns or rows.

T

Tim

Hi Am wondering if there is a way of copying and pasting a worksheet, but
without pasting the hidden cells or groups.

Thanks Tim
 
D

Dave Peterson

Select your range
Edit|goto|special|visible cells only
Edit|copy
to the other worksheet
edit|paste
 
Top