How could one start a macro when a cell value within a range is updated/changed?
The challenge is that i have a fairly big matrix of 800 rows times 365 collumns which contain a macro to check column by column for double entry and change the background of the cell if it exist. This is way to heavy to have running non stop, so a better way would be to have the macro run for a spesific column whenever a value in that column is changed.
Anyone have a good idea to how this could be solved? and maybe a code that would handle this variation? I have found many examples of how to do this when a single cell is cahnged, but this would need to look at a given matrix instead.
Thanks for any help
The challenge is that i have a fairly big matrix of 800 rows times 365 collumns which contain a macro to check column by column for double entry and change the background of the cell if it exist. This is way to heavy to have running non stop, so a better way would be to have the macro run for a spesific column whenever a value in that column is changed.
Anyone have a good idea to how this could be solved? and maybe a code that would handle this variation? I have found many examples of how to do this when a single cell is cahnged, but this would need to look at a given matrix instead.
Thanks for any help
