I have a global matrix, 36 columns x 24 rows, made up of 6 €“ 12 x 12 sub
matrices.
I want to write a macro that will determine which 12 x 12 RANGE contains the
ACTIVECELL and then REPLACE a specific value in that sub matrix.

I have tried to write nested IF statements e.g.
IF(Activecell()<(€œM13€�),Range(€œA1:L12€�),IF (Activecell()<(€œY13€�)€¦etc
But each variation I make still fails with syntax or compile errors.
Can anyone please help

Rewop Eilsel