When I run macro, the text disappears

[1368468485]

I am new to writing macros, and I'm trying to create one that automatically formats a report I have to generate weekly from the output I get from our scheduling program. When I run the macro, the formatting happens correctly, but all of the text in the boxes disappears. Does anyone know why this would happen?
Here is my code:

Please Login or Register  to view this content.

[xladept]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[6StringJazzer]

When I run the macro, the formatting happens correctly, but all of the text in the boxes disappears.

What boxes do you mean?

There are deletions in this code, could that be what's removing your text?

Please Login or Register  to view this content.

Also you have "macro recorder bloat". There is probably more code that what you really need. For example, in

Please Login or Register  to view this content.

you could probably get away with

Please Login or Register  to view this content.

[1368468485]

Here is the before and after of what I'm trying to accomplish

Sample Workbook.xls

[1368468485]

I've replied with a before and after of what I'm trying to do. The deletions are for getting rid of extra columns that I don't need in my final sheet. When I run the macro I have now, the formatting of the text boxes (font, borders, etc.) is correct, but the actual text is gone, like something just cleared the contents.

[Norie]

There are no textboxes in the uploaded workbook.

[xladept]

I trimmed your code some - see if it's what you need:

Please Login or Register  to view this content.

[1368468485]

Thank you!!!

[xladept]

You're welcome and thanks for the rep!