Ctrl Down recorded macro is not working as expected

38 Views Asked by At

The macro I have recorded is not acting as expected.

I am selecting cell H1 and then Ctrl+ down to the next cell with data but it just doesn't seem to move from H1

function UntitledMacro1() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Auto Print'), true);
  spreadsheet.getActiveSheet().setFrozenRows(0);
  spreadsheet.getRange('H:H').activate();
  spreadsheet.getActiveRangeList().setFontColor('#ffffff');
  spreadsheet.getRange('H1').activate();
  spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Lables'), true);
  spreadsheet.getRange('T7').activate();
var selection = SpreadsheetApp.getActiveSpreadsheet().getSelection();
var currentCell = selection.getCurrentCell();
};

0

There are 0 best solutions below