I am a beginner and I am trying to create an Excel Macro to do the following.

When any cell in column AF = “Y”, I want to copy and paste Values and number formatting in cell M, T and AM:AO in the same row.

Currently all those cells have formulas in them.

Any help is much appreciated.

Sub PasteContitionalSpecial()

Lastrow = .Range("AF" & Rows.Count).End(xlUp).Row

Range("AF" & r).Value = "Y"

Range("M").Copy = Range("M").xlPasteValues

I tried variations of the above with no success.