Hi
typoe: replace
dim cell as rng
with
dim cell as range

--
Regards
Frank Kabel
Frankfurt, Germany

"jose luis " schrieb im
Newsbeitrag ...
Thank you Frank

I think your proposal is the solution to my problem. Now i 'm having
troubles with the syntaxis. When I run the Macro i get a
"user-defined
type not defined". I think the assigment of rng as Range and then
cell
as rng is not working. Could you continue helping me to get this
done?

As you see I 'm not very knowlegdable in VBA .But "with a little help
from my friends" all can be done.


Thanks again!!!

Jose Luis
Monterrey
Mexico

What an amazing thing is the Internet!!!, I can stop be surprised! by
the COMMUNity achieved.


---
Message posted from http://www.ExcelForum.com/