All,
i have a macro that ive created using record function, as new to macros! i have an IF formula in two columns, when i record the macro, it inserts a "1" or a "2" in specific columns based on whether there is any cell info in column A, i have option copied this formula down to 1000 rows, But if my spreadsheet is only 100 rows long, the macro still creates the IF formula from 101-1000 and formula is still in the cells, when i save as csv file and try to import into sage it errors, only by manually selecting cells beyond last row and deleting then re-importing into sage does it import.
so i think im looking for a code that detects last row (inc formulas) then deleting below it
can anyone assist?
Bookmarks