Copy Specific Cells from Last Row in Range.

Hi Everyone

In my example worksheet each row from 3:69 is populated with formulae and values across columns C:W.

I'm looking for advice on how to select columns D:M in the last populated row and copy the formulae from them into the corresponding columns in the next available row using VBA, please.

Thanks very much in advance.

Please Login or Register  to view this content.

Hi Bob

Apologies for the delayed response.

Thanks very much for your solution, which I have only just got round to successfully implementing in my workbook.

I may be back for a little more advice in the future if that's OK.

Thanks again.