G
Gunny
I am running excel 2007 and I have 23 worksheets in a workbook. I have no
links or hidden rows or colums. My biggest sheet is A1: AW8096. I use VB
macros to add lines and move data from one set of workbooks to this one. I
have built several sheets using this proceedure.
All of a sudden I get the error "Cannot shift objects off sheet" when I run
a routine I have 50,000 times.
I have checked to make sure there are no hidden comments, row or columns. I
have deleted most of the worksheets and I still get the error. I have made
copies of the workbook and used different file types to save it. I can
create a new black sheet in the workbook that is empty and the same thing
happens.
The only way I can get it to work is to creat a new blank workbook and copy
and paste the sheets into the new workbook. Yes I have serched the FAQ and
knowledge base and tried all of those fixes as well. Does anyone have any
idea what the problem is?
Gunny
links or hidden rows or colums. My biggest sheet is A1: AW8096. I use VB
macros to add lines and move data from one set of workbooks to this one. I
have built several sheets using this proceedure.
All of a sudden I get the error "Cannot shift objects off sheet" when I run
a routine I have 50,000 times.
I have checked to make sure there are no hidden comments, row or columns. I
have deleted most of the worksheets and I still get the error. I have made
copies of the workbook and used different file types to save it. I can
create a new black sheet in the workbook that is empty and the same thing
happens.
The only way I can get it to work is to creat a new blank workbook and copy
and paste the sheets into the new workbook. Yes I have serched the FAQ and
knowledge base and tried all of those fixes as well. Does anyone have any
idea what the problem is?
Gunny