code sequence works manually but not as a macro?

[mal]

Thanks for your work. I tried loading it into my spread sheet and when I ran it I got a white cross in a red circle with the number 400. Attached is my file with your code in it.