'Formating Copied to new Sheet Google Scripts (Google Sheets)

Trying to get the formatting copied over from the front sheet, but it takes the forumla which is a import range, is there any way to achieve this without showing the ref error.

 function BrandSheets() {
  var ss = SpreadsheetApp.getActive();
  var Frontsheet = ss.getSheets()[0];
  var Header_range = Frontsheet.getRange(1,1,1,13);
  
  var CurrentBrand = Frontsheet.getRange(2,3).getValue();
  var CurrentTopBrand = 2;
  var CurrentBottomBrand = 2;
  var CheckBrand = CurrentBrand;

  Frontsheet.getRange(1,3).activate();
  Frontsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();
  var FLastCell = Frontsheet.getActiveCell();
  var FLastRow = FLastCell.getRow();

  for(var i = 2;i<=FLastRow+1;i++){
    var CheckBrand = Frontsheet.getRange(i,3).getValue();
    if (CheckBrand == CurrentBrand){
      var CurrentBottomBrand = i
    } 
    else{
      var CurrentBottomBrand = i
      var BrandTable = Frontsheet.getRange(CurrentTopBrand,1,CurrentBottomBrand-CurrentTopBrand,13);
      var NewSheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet(CurrentBrand);
      var NewHeader_range = NewSheet.getRange(1,1,1,13);
      var NewBrandTable = NewSheet.getRange(2,1,CurrentBottomBrand-CurrentTopBrand,13);
      Header_range.copyTo(NewHeader_range,{contentsOnly:true});
      BrandTable.copyTo(NewBrandTable);
      var CurrentTopBrand = i;
      var CurrentBrand = Frontsheet.getRange(i,3).getValue();
      SpreadsheetApp.getActiveSpreadsheet().getSheets().forEach( sheet => sheet.setTabColor("grey"));
    }
    }
}

I tried Header_range.copyTo(NewHeader_range,{contentsOnly:true,formatOnly:true});

But this is where the bug of ref comes up. Issue Ref

Many thanks,



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source