My apologies for the original post not so informative for your
diagnosis.

Still not getting the point of typing 'dim UserInterfaceOnly<enter'
and then deleting it straight away afterwards...maybe because I dont
understand how Excel's memory works