I haven't seen the code, but if you have

Dim Rng As Range
Dim Cell As Range

Rng is a variable, not a prototype for another variable. The prototype for
both is Range.

On Sun, 12 Sep 2004 17:32:08 -0500, jose luis
wrote:

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/