error message when inserting columns/rows

bherndon

New Member
Joined
Sep 1, 2002
Messages
4
I get an error message on a certain worksheet I use to calculate inventory. No other worksheets in the workbook give me the same message, they seem to work perfectly. When I right click to insert a column/row, the error message says I need to clear all of the space to the right and below because it cannot shift non-blank cells off the worksheet. I do what it tells me, but it still gives me the error message.
This message was edited by bherndon on 2002-09-02 14:44
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
bherndon,

Welcome to the board :)

Have You checked column IV if there exist any values and in row 65536?

If You are sure that You have not put any data in this column or row the easiest way is to delete them and then try to insert again.

Another possible situation is that You need to reset the last used cell. Check out the free ASAP utility that has this tool included.

http://www.asap-utilities.com/
 

bherndon

New Member
Joined
Sep 1, 2002
Messages
4
I cannot delete the data because it has existing information in it that I need to keep. How do I reset the last used cell?
 

XL-Dennis

Well-known Member
Joined
Jul 27, 2002
Messages
1,920
bherndon,

Do You mean that You have data in the last column och the last row? If so is it possible for You to move the data elsewhere?

XL is limit to 256 columns & 65536 rows and if we keep data in the last column/row XL cannot insert a new column / row.

Reset last used range is either done by VBA-code, for instance ActiveSheet.UsedRange or by a third-part tool like the free ASAP-utility :)
 

Forum statistics

Threads
1,143,640
Messages
5,719,986
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top