Yep, should have been as plain as the nose on my face. I needed the quotes where they are in the original string for the formulat to work when I insert it into a cell, so I had to replace them with "Chr$(34)" calls and put it in a variable instead of a const (I don't know of a way of escaping the quotes VB in the string like you can in C/C++).
Originally Posted by macropod
This is how it turned out:
Sometimes you get so close to something you can't see the obvious problems.
Again, thanks for the help.