LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default Error in Insert Row command.

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Error Message - "Command Text not set for command obje Jeff Divian Excel Discussion (Misc queries) 0 November 7th 07 10:26 PM
insert row / insert column command buttons fairgreen Excel Worksheet Functions 1 October 29th 07 02:41 PM
To set up a command that will insert a row, every fifth row? shanespop2b New Users to Excel 3 May 6th 05 04:32 PM
Insert comment command Russell Stevenson Excel Programming 0 November 10th 03 07:32 PM
Insert comment command Russell Stevenson Excel Programming 3 November 9th 03 08:45 PM


All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"