Thanks a ton Miguel! I managed to get it to do exactly what I wanted
doing that. I've never played with macros before and I've only played
with VBA in Access so I didn't know you could do that. It's kinda like
building a query in QBE in Access and then looking at the SQL code it
creates. Very handy.

I guess some posts I read elsewhere were incorrect about formatting
text through VBA. At least in a header anyway.

Thanks again Miguel and Dave!


--
bozrdang
------------------------------------------------------------------------
bozrdang's Profile: http://www.excelforum.com/member.php...o&userid=34463
View this thread: http://www.excelforum.com/showthread...hreadid=542243