I have a spreadsheet with variable rows that I would like to have a macro declare the last row of the range starting at row B6 and ending at last row of data, loop through column A to find blanks when a blank is found I need a formula in column AA of that row that divides Z/Y