Worksheet_Change Still Not Executing....
The purpose of the code is to
1) identify if an entry has been made to a specific region of a
worksheet - in this case, a six columned area.
2) determine the location of the cell cell selected - and based on the
column that that data comes from,
look at the other 5 columns within this 6 columned area - within the
same row and determine what the values of the other 5 columns, same
row.
For instance, if the cell selectes is in column a, find out the values
in column b-e, same row
If cell selected is in column b, find out the value in column a, c-e,
same row
If cell selected in in column c, find out the values in column a-b,
d-e, same row
etc.
Eventually, i will be passing these values to various functions that
will validate the entry being made based on the values.
|