Changing a macro to use a loop

Hi, I'm using a macro to drag down a formula across a worksheet then again further down the worksheet which is working ok but I know there has to be a better way of doing it. At the moment everytime I add a new collumn I have to edit the macro over and over and its getting out of hand. I know there must be a way of rewiting the macro into a loop but my skills are obviously still new. If anyone could help I would appereciate it.

Here's the macro: Sorry I can't remeber how I'm supposed to post VBA - I hope this is right.

Please Login or Register  to view this content.

This continues over to column AO so far then I drop down a few rows and do it again:

Please Login or Register  to view this content.

I think I need to set variables that set the row and column each time. maybe a "drag formula one column at a time from row x to row y until column header is empty then move to the new row and repeat"?

You don't need to do each column individually, you can replace the first block of code with:

Please Login or Register  to view this content.

and the second block of code with:

Please Login or Register  to view this content.

I don't see a pattern in the rows in order to create a loop.

Thanks Regulduy, I didn't realise it was that simple! I don't need a loop now. Brilliant.

Hi - you need:

Please Login or Register  to view this content.