Hi All,
with VBA, I want to highlight row and column based on selected cell but within the current region, dynamically with change in cell selection.
EntireRow.Interior.Color selects whole row/column, but how to restrict the same within current region with VBA.
A B C D
1 94 94 33 74
2 59 39 91 53
3 51 80 71 66
4 63 50 71 62
5 81 62 33 33
6 28 77 99 48
7 71 29 72 70
8 95 54 42 49
with VBA, I want to highlight row and column based on selected cell but within the current region, dynamically with change in cell selection.
EntireRow.Interior.Color selects whole row/column, but how to restrict the same within current region with VBA.
A B C D
1 94 94 33 74
2 59 39 91 53
3 51 80 71 66
4 63 50 71 62
5 81 62 33 33
6 28 77 99 48
7 71 29 72 70
8 95 54 42 49
