Dear All,

I have small VBA project, with some worksheets and userforms.

In Material worksheet, when I try to insert one Row Excel is giving me
this error saying..........

To prevent possible loss of data Excel can not shift non blank cells
off the worksheet.

Try to delete or clear the calls to the right and below your data then
select call A1, and save your work to reset the last cell used.


and when I try to delete any Row Excel is not responding and its
Stuck totally.

This is happening only Material worksheet, all other sheets are
working well.

Can any one help me to resolve this problem.

Shahzad

Hi,

You may have data on the last row of the worksheet. If you have and you try
and insert a row Excel doesn't like it. Move the data from the last row to
resolve it.

Mike

" wrote:

Dear All,

I have small VBA project, with some worksheets and userforms.

In Material worksheet, when I try to insert one Row Excel is giving me
this error saying..........

To prevent possible loss of data Excel can not shift non blank cells
off the worksheet.

Try to delete or clear the calls to the right and below your data then
select call A1, and save your work to reset the last cell used.


and when I try to delete any Row Excel is not responding and its
Stuck totally.

This is happening only Material worksheet, all other sheets are
working well.

Can any one help me to resolve this problem.

Shahzad

On Sep 13, 11:48 am, Mike H wrote:
Hi,

You may have data on the last row of the worksheet. If you have and you try
and insert a row Excel doesn't like it. Move the data from the last row to
resolve it.

Mike



" wrote:
Dear All,

I have small VBA project, with some worksheets and userforms.

In Material worksheet, when I try to insert one Row Excel is giving me
this error saying..........

To prevent possible loss of data Excel can not shift non blank cells
off the worksheet.

Try to delete or clear the calls to the right and below your data then
select call A1, and save your work to reset the last cell used.

and when I try to delete any Row Excel is not responding and its
Stuck totally.

This is happening only Material worksheet, all other sheets are
working well.

Can any one help me to resolve this problem.

Shahzad- Hide quoted text -

- Show quoted text -



Hi Mike,

Thank you for promp reply. I checked my last row of the worksheet,
there was a Sum formula, I removed the formula but still I am facing
the same problem, You are reight if some thing is in the last row of
the worksheet, then we can not insert row, I checked this in other
sheet.

Now what is the solution. I removed every thing from the last row of
the sheet, again I am unable to insert row in the worksheet. and
unable to delete the row in worksheet. please help me

shahzad

What error do you get if you select the last row (65536?) and then delete

Mike

" wrote:

On Sep 13, 11:48 am, Mike H wrote:
Hi,

You may have data on the last row of the worksheet. If you have and you try
and insert a row Excel doesn't like it. Move the data from the last row to
resolve it.

Mike



" wrote:
Dear All,

I have small VBA project, with some worksheets and userforms.

In Material worksheet, when I try to insert one Row Excel is giving me
this error saying..........

To prevent possible loss of data Excel can not shift non blank cells
off the worksheet.

Try to delete or clear the calls to the right and below your data then
select call A1, and save your work to reset the last cell used.

and when I try to delete any Row Excel is not responding and its
Stuck totally.

This is happening only Material worksheet, all other sheets are
working well.

Can any one help me to resolve this problem.

Shahzad- Hide quoted text -

- Show quoted text -



Hi Mike,

Thank you for promp reply. I checked my last row of the worksheet,
there was a Sum formula, I removed the formula but still I am facing
the same problem, You are reight if some thing is in the last row of
the worksheet, then we can not insert row, I checked this in other
sheet.

Now what is the solution. I removed every thing from the last row of
the sheet, again I am unable to insert row in the worksheet. and
unable to delete the row in worksheet. please help me

shahzad

On Sep 13, 2:40 pm, Mike H wrote:
What error do you get if you select the last row (65536?) and then delete

Mike



" wrote:
On Sep 13, 11:48 am, Mike H wrote:
Hi,

You may have data on the last row of the worksheet. If you have and you try
and insert a row Excel doesn't like it. Move the data from the last row to
resolve it.

Mike

" wrote:
Dear All,

I have small VBA project, with some worksheets and userforms.

In Material worksheet, when I try to insert one Row Excel is giving me
this error saying..........

To prevent possible loss of data Excel can not shift non blank cells
off the worksheet.

Try to delete or clear the calls to the right and below your data then
select call A1, and save your work to reset the last cell used.

and when I try to delete any Row Excel is not responding and its
Stuck totally.

This is happening only Material worksheet, all other sheets are
working well.

Can any one help me to resolve this problem.

Shahzad- Hide quoted text -

- Show quoted text -

Hi Mike,

Thank you for promp reply. I checked my last row of the worksheet,
there was a Sum formula, I removed the formula but still I am facing
the same problem, You are reight if some thing is in the last row of
the worksheet, then we can not insert row, I checked this in other
sheet.

Now what is the solution. I removed every thing from the last row of
the sheet, again I am unable to insert row in the worksheet. and
unable to delete the row in worksheet. please help me

shahzad- Hide quoted text -

- Show quoted text -


Mike,

I selected the last row in the sheet and delete every thing, but again
I am unable to insert one row or delete one row. when I use this
commands my Excel is stoped working and not responding at all .

What to do.???

shahzad