Should be easy to modify. Move the add to before the loop

keep track of what column you are copying to. Increment after copying.



--
regards,
Tom Ogilvy

"Darin Kramer" wrote in message
...
Kinda got it to work by ignoring error line of code, BUT also, I need
the result to be copied to the SAME sheet each time, ie NOT to a new
sheet, ie move one column along and then paste the result, move one
column along and paste the result, etc etc

Regards

Darin


*** Sent via Developersdex http://www.developersdex.com ***