Excel script to copy/paste special values for specific rows based on column criteria

Hello, I am attempting to write a script to "lock down" values (e.g. copy / paste special values) and eliminate the current formula. I only want this action to apply to monthly values (col. AF - AQ) that are in rows that have "Q1 FRCST", col G when our forecast is finalized. I would click the "script button" when I wanted this action to occur. I am just starting to figure out scripts. Can I do this by script or another path (VBA or even formula)? Would prefer not to do this via VMA (macro).

I have added the Excel tab that has the information as well as snap shot of my current script.

Thank you.

Does this work for you?

PHP Code: 

function main(workbook: ExcelScript.Workbook) {
    let selSheet = workbook.getActiveWorksheet();
    let lr = selSheet.getUsedRange().getRowCount()+1;
    let Range1 = selSheet.getRange("G1:G" + lr);
    let vScenario = Range1.getValues() as string[][];

    for (let i = 3; i < lr; i++) {
        if (vScenario[i][0] == "Q1 FRCST") {
            let TheRange = "AF" + (i + 1) + ":AQ" + (i + 1);
            selSheet.getRange(TheRange).copyFrom(selSheet.getRange(TheRange), ExcelScript.RangeCopyType.values, false, false);
        }
    }
} 


Hello ByteMarks! I appreciate you looking into my question. No errors when running the script, unfortunately the script does not complete the task of copy/ paste special values. The formula remains in AF - AQ.

Hmm works for me.
There were no formulae in AF-AQ of the the attached file, but if you put them in and then run the script, where column G is "Q1 FRCST" (rows 7,13,19,25,31)
then the formulae are replaced with values.

I got it work now. I started a new script rather than editing my old script. Much appreciated!! Thank you!

Great news!