After selecting the range, press the F5 key, click on the Special button, and
check Visible Cells Only

"Cube Farmer" wrote:

I am trying to copy data and not include the rows and columnc that I have
hidden.
I know there has to be an easy way but for some reason I am playing stupid
this morning.
Thanks in advance.