You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Thank you so much! This second one works great!

.Value or .FormulaR1C1 is not important. It's "&( )&" makes it work.

Thousands of thanks again!


{snip}