Change event to track in which column table changes were made

[jaryszek]

Hi Guys,

i have table like below:

Screenshot_10.png

i wrote a macro which is checking if cell in StorageID column was changed (or any other columns inputted in HiddenDV dictionary list). And this is working if you are inputting directly into this column into table.

1. The problem is when i am inserting new column (in D column) error handler is not working (why?):

Screenshot_11.png

2. The second issue is that this is not triggering when i am selecting the last row of table and resizing it manually - how can i trigger it? (to populate more table rows).

3. The same issue when i am deleting whole row from a table - macro is not triggered.

Please help,
this topic seems hard to me.

Please Login or Register  to view this content.

Best,
Jacek

[jaryszek]

Hi,

this code is working like a charm:

i created pivot tables and refreshing them when specific column table was changed.

Please Login or Register  to view this content.