excel vba works from VBA but not from button

I have this code that loops through and prints the correct pallet headers with correct amounts and information.

The VBA works fine when executed from the VBA screen, but only prints the first record the correct amount of times.

Here is my code. I apologize ahead of time this is my first time working with VBA.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

I'm not clear on what your problem is, based on reading the title and then reading the second line of your post. It only prints the first record the correct amount of times when invoked by a button, but prints all records the correct amount of times if executed from VBA?

What module is this code in?
Where is the button?

One thing that jumps out right away are these unqualified Range references:

Please Login or Register  to view this content.

What worksheet do you intend these to refer to?

If the code is in a worksheet module (like Sheet1), these ranges will refer to that worksheet.
If the code is in a standard module (like Module1), these ranges will refer to the active worksheet.

It is generally weak to depend on what sheet is active for references, unless you have a macro that is designed to be called from different sheets.

I do not know what sheet you actually want them to refer to so I can't tell you if this is code is causing your problem, or if it is, how to fix it. However, all your other code provides explicit qualifications, like this, which is a best practice:

Please Login or Register  to view this content.

It sounds like this problem is solved. If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.