Hi Lobo

Tom's changed macro is working for me

Thanks for posting this Patrick

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Lobo" wrote in message ...
Hey Tom,

I'm currently working with a miniature spreadsheet that loosk just like this below:

F G
Name Days Left
Terrel Lobo 5
Terrel Lobo 15
Steve Lobo 14
Terrel Lobo 5
Karen Lobo 5
Terrel Lobo 5

When i run the macro with the second code, I get "This key is already associated with an element of this collection" and no
emails are sent to myself or karen.

If i change the spreadsheet to:

Name Days Left
Terrel Lobo 5
Terrel Lobo 15
Steve Lobo 14
Terrel Lobo 10
Karen Lobo 10
Terrel Lobo 10

and then run the macro, absolutely nothing happens. No email gets sent to Terrel Lobo.

I have no idea what to do to solve this. However if i use the basic code on ron de bruin's site, it sends the email out.

Any ideas tom?