LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Problem of selection.delete

Hi all,
we are currently using MSExcel 2003 version. We are facing a problem of
deleting perticular data by selecting the range. We are first selecting the
specified range and we are doing the selection.delete operation using macro.
But it is selecting the range but it is not deleting. If i gave
selection.clearformats and selection.clearcontents it is deleting fine. The
selection.Delete is working fine for remaining workbooks. can any one give
your opinion about this.
 
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
Copy Selection - Transpose Selection - Delete Selection Uninvisible Excel Discussion (Misc queries) 2 October 23rd 07 04:18 PM
Selection.Replace Problem Dave Excel Discussion (Misc queries) 8 September 20th 07 06:23 PM
Delete Entry Based on Selection AntnyMI Excel Discussion (Misc queries) 1 September 16th 06 06:24 PM
Selection mode problem Richard L. Trethewey New Users to Excel 2 November 23rd 05 07:45 PM
Macro data selection line delete Frantic Excel-er Excel Discussion (Misc queries) 0 May 31st 05 11:46 PM


All times are GMT +1. The time now is 06:23 AM.

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

About Us

"It's about Microsoft Excel"