When trying to save my worksheet I get the following ERROR:

EXCEL.EXE - Application Error

The instruction at "0x3022dd48" referenced memory at '0x00000010" The memory
could not be "read".

The VBA code queries data and then creates sheet "A" and sheet "B" renaming
them each to a unique naming convention. Each sheet "B" references the
corresponding sheet "A" and when the loop is complete all references on sheet
"B" are copy and pasted as values. I believe by the end of the code that
there are no longer any sheet "A" references. What does the above error mean
when trying to save?