Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Event to signal row or columns being added or dde (2000 - 2007)

    Is there a way to catch when a row or column is being added or deleted on a sheet? The Worksheet_Change event does get fired but I am not sure what property to look at to know that a row or column is being added or deleted.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Event to signal row or columns being added or dde (2000 - 2007)

    As far as I know, inserting a row or column does not trigger any trappable events.

    If you had a calculation in a cell in the rightmost column and bottommost row that used the row() and column() functions, inserting/deleting columns would trigger a calculation and this could be trapped, but you would have to be specific in the code of what is being done and someone have the code "discover" what triggered the calculation...

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Event to signal row or columns being added or dde (2000 - 2007)

    As Steve noted, there is no event that fires when the user inserts or deletes rows or columns, but you might get some ideas from Capture Deleted Rows on the Daily Dose of Excel site.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •