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: 17
Default SOS:Know Deleted/Inserted Range in Excel 97/2000

SheetCalculate event is fired whenever row/col insert/delete is done.
And only calculate function 'Workbook_SheetCalculate(ByVal Sh As Object)' is
called in Excel 97. The Object parameter has a Worksheet object.
Is there any way i can know what range was deleted/inserted.


 
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
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted sga[_2_] Excel Worksheet Functions 3 April 12th 11 01:23 PM
Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS Martin ©¿©¬ @nohere.net Excel Discussion (Misc queries) 3 April 12th 08 05:13 PM
If a Row is inserted or is a row is deleted then...... ML Excel Worksheet Functions 6 December 11th 07 07:26 PM
Window 2000 : How to protect a file from being deleted ? Mr. Low Excel Discussion (Misc queries) 4 August 30th 07 02:39 PM
allow users to edit a range in excel 2000 jimar Excel Discussion (Misc queries) 6 August 24th 05 08:12 PM


All times are GMT +1. The time now is 08:21 PM.

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"