I think this should be fairly simple. But lets say I have a named range in the middle of the sheet and if a cell in that range is changed, I want to run some code.

I have the Worksheet_Change event, and I set a variable = to the Intersect of the target and my named range.
Assuming the intersect is not nothing, I need to find the Cells(x,y) value of that cell in the named range. There should be a way to do that, right? I'm just not sure how to get the x,y for it.

Basically I have the same categories along the top and side and filling in one half of the intersections should be able to flip the other half automatically along the diagonal. So if in (Cells(x,y) x>y, then y,x needs to be the inverse of the value. I can get that, once I figure out how to get the cells reference. I suppose I can always find the overall row/column and adjust based on where the upper corner of the named range is, but I was hoping for more dynamic code.

Best regards,
Fizziii