joemeshuggah
Board Regular
- Joined
- Jul 18, 2008
- Messages
- 161
i have a macro that deletes all rows from row 4 to 65536.
i then paste results from a query in row 4, and then run a macro that loops through each column, adds a column, and adds a ranking formula. sometimes, but not all of the time, i get an error message saying:
Run-time error '1004'
To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing CTRL+END, and delete or clear all in cells between the last cell and the end of your data. Then select cell A1 and save your workbook to reset the last cell used.
When i hit CTRL+END, I arrive at a cell, but it is blank. If I delete everything, the problem still occurs. Anyway around this?
i then paste results from a query in row 4, and then run a macro that loops through each column, adds a column, and adds a ranking formula. sometimes, but not all of the time, i get an error message saying:
Run-time error '1004'
To prevent possible loss of data, Microsoft Excel cannot shift nonblank cells off the worksheet.
Try to locate the last nonblank cell by pressing CTRL+END, and delete or clear all in cells between the last cell and the end of your data. Then select cell A1 and save your workbook to reset the last cell used.
When i hit CTRL+END, I arrive at a cell, but it is blank. If I delete everything, the problem still occurs. Anyway around this?
