I have this script that I'm trying to use to replace data in a range with a specific value. The script works well when I run it manually, however when I set up a time trigger, the script fails with error message:

"The coordinates of the target range are outside the dimensions of the sheet."

This is the script:

function A1() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('B4:E23').activate();
  spreadsheet.getRange('Z1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('J4:M23').activate();
  spreadsheet.getRange('Z1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('R4:U23').activate();
  spreadsheet.getRange('Z1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('AF4:AI23').activate();
  spreadsheet.getRange('Z1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('AN4:AQ23').activate();
  spreadsheet.getRange('Z1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('AV4:AY23').activate();
  spreadsheet.getRange('Z1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('F4:I23').activate();
  spreadsheet.getRange('AZ1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('N4:Q23').activate();
  spreadsheet.getRange('AZ1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('V4:Y23').activate();
  spreadsheet.getRange('AZ1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('AB4:AE23').activate();
  spreadsheet.getRange('AZ1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('AJ4:AM23').activate();
  spreadsheet.getRange('AZ1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
  spreadsheet.getRange('AR4:AU23').activate();
  spreadsheet.getRange('AZ1').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
};

Can anyone assist?

Thank you!