I use a little code in accordance with a CF rule that highlights an entire row no matter what column I'm in.
Normally it works like a charm, but I just added a Transpose {array} formula to a couple of cells and now I get this error every time I click on a cell with that formula. Nothing breaks, and I can just click end to continue, but I don't want to explain people to just not click those cells. Googling this error gives me results that go back 7 or 8 years and have nothing to do with the version of excel that I'm using (2013)
Any way to fix this, or should I just park the transposed data in a hidden helper column and reference the visible ones to there?
Bookmarks