Macro to change vlookup cells to values

[Tim Stoner]

Hi All
I was wondering if anyone could help me with a macro to change the cells O23 -O33 from Vlookup values to Pasted values only so if I change the value in referenced cell it wont change my existing spreadsheets
Many Thanks
Tim

 

[Yongle]

Range("O23:O33").Value = Range("O23:O33").Value

Above is for active sheet

 

[Tim Stoner]

Range("O23:O33").Value = Range("O23:O33").Value

Above is for active sheet

Thank you very much