79642006

Date: 2025-05-28 10:30:46
Score: 1.5
Natty:
Report link

For what it's worth, I experienced this error when I inadvertently ran a sub containing "Application.Screenupdating = True" from a button, while actively editing a cell with a drop-down picklist (based on a dynamic range).

The error would not resolve in debug - I had to end execution, and at that point, the code ran fine from the button, as the cell / dropdown was no longer active.

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: RedChris