i am trying to just copy over the final totals associated with each employee
but when i paste it i gives me all the hidden cells.

Macro - Have a look in vba help for SPECIALCELLS
Formula - copytouch f5 key goto specialvisible
--
Don Guillett
SalesAid Software

"JLovato" wrote in message
...
i am trying to just copy over the final totals associated with each
employee
but when i paste it i gives me all the hidden cells.

Try F5SpecialVisible cells onlyOK

Copy those selected.


Gord Dibben Excel MVP

On Thu, 3 Mar 2005 14:39:02 -0800, "JLovato"
wrote:

i am trying to just copy over the final totals associated with each employee
but when i paste it i gives me all the hidden cells.