I'm trying to pattern match according to a given set of cells. For example, I'd like find the locations(row/column) of the headers of a spreadsheet, but the headers may slightly vary in name from worksheet to worksheet. I considered storing the range of cells in an array and using a regex from there...

I have a worksheet that runs a query from an external data program. I have made a macro that refreshes the worksheet and this works ok. Is there a way I can get Scheduled tasks to automatically update this workbook eg overnight. I do not want to leave the workbook open either. Can task scheduler ope...