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();
};