I have a table I want to modify. The actions triggered by modifications varies depending on original data and modified (resulting) data and the location of the data in table. Because there is no Before_Change event, my idea was to put the original table in a array and to compare the modifications (and their locations) based on the Worksheet_Change event... BUT.. I don't know how to preserve array data outside its populating sub:
Please Login or Register to view this content.