Castro Electronica
unread,Sep 27, 2022, 3:47:46 PM9/27/22You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Buenas tardes me dirijo a ustedes ya que dominan el tema y sin embargo yo recien empiezo y no encuentro la solucion,desde ya muchas gracias.
Necesito ejecutar esta macro
function jj() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('22:22').activate();
spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 1);
spreadsheet.getActiveRange().offset(0, 0, 1, spreadsheet.getActiveRange().getNumColumns()).activate();
spreadsheet.getRange('A22').activate();
spreadsheet.getRange('D2').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.getRange('B22').activate();
spreadsheet.getRange('E2').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
spreadsheet.getRange('E2').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
spreadsheet.getRange('D2').activate();
spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
};
cuando termine de editar la celda e2 y pulse enter,para que haga de forma automatica y asi no colocar el boton de la macro.