Erreur sur MACRO

Bonjour

J'ai une erreur sur ma macro (Exceeded maximum execution time)

Avez vous une solution.

Bonne Journée.

function MAJDOSSIER() {
  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var f1 = SpreadsheetApp.getActive();
  var f2 = doc.getSheetByName('TABLEAU ROUGE');
  var adresses = ["AM3","AN4","AU4","AP6","AM8","AN10","AT10","S27","S29","S31","S33","S35","S37","AN27","AN29","AN31","AN33","BI27","BI29","BI37","O49","AA49","AG49","AM49","AS49","AY49","BE49","BK49","O51","AA51","AG51","AM51","AS51","AY51","BK51","O53","AA53","AG53","AM53","AS53","AY53","O55","U55","AA55","AG55","AM55","AS55","AY55","O57","U57","AA57","AG57","AM57","AS57","AY57","O59","U59","AA59","AG59","AM59","AS59","AY59","O61","U61","AA61","AG61","AM61","AS61","AY61","O63","U63","AA63","AG63","AM63","AS63","AY63","O65","U65","AA65","AG65","AM65","AS65","AY65","O67","U67","AA67","AG67","AM67","AS67","AY67","O69","U69","AA69","AG69","AM69","AS69","AY69","O71","U71","AA71","AG71","AM71","AS71","AY71","O73","U73","AA73","AG73","AM73","AS73","AY73","O75","U75","AA75","AG75","AM75","AS75","AY75","O77","U77","AA77","AG77","AM77","AS77","AY77","O79","U79","AA79","AG79","AM79","AS79","AY79","O81","U81","AA81","AG81","AM81","AS81","AY81"];
  var destination = ["K","L","M","N","U","S","T","W","AB","C","AJ","AF","E","AC","AD","AG","AH","AI","AL","HO","AN","AO","AP","AR","AS","AT","HJ","AU","AW","AX","AY","AZ","BA","BB","BC","BE","BF","BG","BH","BI","BJ","BL","BM","BO","BP","BQ","BR","BS","BU","BV","BW","BX","BY","BZ","CA","CC","CD","CE","CF","CG","CH","CI","CK","CL","CM","CN","CO","CP","CQ","CS","CT","CU","CV","CW","CX","CY","DA","DB","DC","DD","DE","DF","DG","DI","DJ","DK","DL","DM","DN","DO","DQ","DR","DS","DT","DU","DV","DW","DY","DZ","EA","EB","EC","ED","EE","EG","EH","EI","EJ","EK","EL","EM","EO","EP","EQ","ER","ES","ET","EU","EW","EX","EY","EZ","FA","FB","FC","FM","FN","FO","FP","FQ","FR","FS","FE","FF","FG","FH","FI","FJ","FK"];
  var values = f2.getRange('B:B').getValues().join().split(","); 
  var num = f1.getRange('B14').getValue().toString();
  var ligne = values.indexOf(num) + 1
  for (var i = 0; i < adresses.length; i++){
    f2.getRange(destination[i] + ligne).setValue(f1.getRange(adresses[i]).getValue());
  }
  Browser.msgBox(num + ' modifié !');
}
Rechercher des sujets similaires à "erreur macro"