I have what I am sure is a simple query, I have a macro that runs a VLOOKUP from C5 to P5 and what I need it to do is then run the macro in the cells in the rest of the columns, but as I have just inserted a blank column to put my macro in, it goes and copies down to the end of the sheet, so I would need to specify the range to copy it down but only if there is something in the previous column.

The column length will vary daily as the sheet is updated, so one day it needs to copy from C5:P5 to C500:P500 and the next day copy from C5:P5 down to C1000:P1000 and so on

I have managed to get it to copy text down but not my Macro/formula

Can anyone help please?

Thanks