Posted 10 September 2017, 10:58 am EST
I have no frozen columns, I have no problem. I freeze some columns, my code enters an endless edit end loop after keying in a value and tabbing out of the edited cell.
Tough to explain... let's say I have visible columns frozen up to and including column 4 (frozencolumn.count = 5). Now, I key a value into column 15 of the active row. After entering the value, I tab out of the active cell. My code analyzes many things, but the only change my code makes to the spreadsheet is to put a calculated value into column 16 within the active row. I expect the EditEnd event to fire once for column 15, but it just keeps firing. To be clear, I thought it might be firing for the coded change to column 16, but a check shows it just keeps firing for column 15.
With no other change to my code, I can skip freezing columns so there are none frozen, duplicate my entry into column 15, allow the code to place the calculated value into column 16 within the active row and the EditEnd event only fires once.