Hello,
davesexcel has two example codes that shows how to do this with a loop
and then a faster way, using Evaluate. The evaluate code has been very
usefull for me, especially when I want to manipulate 30K rows. The
results are almost instant, while the looping code takes several
seconds.
Check it out here
http://www.davesexcel.com/vbacodes.htm#724367015