More efficient way of copying & pasting formula into my large spread sheet

[Excellover123]

Hi Message Board.
Just wondering if someone could help/point me in the right direction.
Currently, i have some VBA code that copies a range of cells (Q5:DC5 (This the named range called Master_MRP)) that houses the below/attached formula & this loops through & first pastes as formula & then copies & pastes as values (as per the below/attached snip) - I'm looking to see if there's a better/faster calculating solution?

Thank you for your help/time.

Regards, Gary

 

[Excellover123]

Just wanted to note that where the formula is point to Q$34, this changes to R, S, T etc until it gets to DC. Perhaps a spilled range (Q34:DC34) inside of VBA would work?