Loop not finishing

Is there any way I can change the loop I have in place so that it will work? I'm trying to use the recorded macro so I can use a similar loop for other data without having to know how to actually write code. Lazy, I know, but I don't have the time unfortunately.

---------- Post added at 09:48 AM ---------- Previous post was at 09:42 AM ----------

Nevermind, this works awesome. Thanks a bunch, I appreciate it.

Originally Posted by boomersooner5136

so I can use a similar loop for other data

Will the 'similar' loops still be using the same cut and paste data in fixed size blocks?

The code in my previous post can be made more generic so you can use it on any size range if that would help?