Looping Macro Code

[asifmian55]

I have written a macro but it is too long. I tried to use a loop but it did not work. I need help from the experts. Your prompt response will be very highly appreciated.

The spreadsheet is attached.

[gmr4evr1]

One way to shorten the code is to remove most or all of the Select and or Selection parts of the code and rewrite them.
So this...

Please Login or Register  to view this content.

Becomes this...

Please Login or Register  to view this content.

Do this for all the copy/paste sections of the code.

[asifmian55]

One way to shorten the code is to remove most or all of the Select and or Selection parts of the code and rewrite them.
So this...

Please Login or Register  to view this content.

Becomes this...

Please Login or Register  to view this content.

Do this for all the copy/paste sections of the code.

This will not help much. I how can do the same using For/Next loop