Would have been better to post a sample Excel file rather than a picture, then there's no questions as to what you're working with.
Anyway, here's the test file I put together for this, "ScratchPad" is hidden.
The code is for this file, not necessarily yours, unless I've got everything right as to what you're working with.
As for adding data... doesn't matter where you put it as everything gets re-sorted. I'd just stuff it on the bottom as another record.
Instant replay.... never seen or heard of that, can't help there.
You're past this part of things but just for info...
Don't know about Excel 2013 but my 2010 installation had
Disable all macros without notification as a default setting.
I changed it to Disable all macros with notification.
This was done under File > Options > Trust Center > Trust Center Settings > Macro Settings.
|