how do you paste just specific info and not the hidden info?

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 - copy>touch f5 key goto special>visible
--
Don Guillett
SalesAid Software
[email protected]
"JLovato" <[email protected]> wrote in message
news:[email protected]...
> 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 F5>Special>Visible cells only>OK

Copy those selected.


Gord Dibben Excel MVP

On Thu, 3 Mar 2005 14:39:02 -0800, "JLovato"
<[email protected]> 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.