Should include Option Explicit in every module header. In the VBE > Tools > Options > check "Require Variable Declaration". You will have to type it into existing modules.

Define "full size" and display where in Excel?

A delete procedure should be simple. Use Kill statement https://learn.microsoft.com/en-us/of...kill-statement