Copy an excel worksheet

[Injun]

How can I copy only the visible rows from one excel work book to another ?

Is there any property like visible range ?

Is it possible to do. Because I have multiple pivottables on an excel report where I have to hide the headers of certain pivottables . Now when I manually copy them to another workbook the hidden rows show up.

thanks

 

[RonRepp]

Try the UsedRange property; however, I don't know what this does for hidden rows/columns.

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.