Hey Todd,
Welcome to the forum! 
You should post an actual example of what you're trying to do to the forum.
It sounds like you're making your task overly complicated, but I can't really tell from your description.
If you haven't read this it's worth a couple of minutes of your time.
Tip: How Do I Get The Best Answer in the Shortest Time?
This too:
How to Post Your Macro to the Forum
-Chris