Hi @RandallReetz - it would be a lot easier to give help if others could see your actual macro.
Have a look here:
Which shows how to post your macro...
For more information, see the wiki Searching the Forum for Answers section.