Not sure if this can be done in a macro
 

I want to take a data set that comes out of a cognos report and have i
formated by a macro. I am not sure if it is possible to tell a macr
to look at a column heading and if it is started with something such a
prct_ to know to make that column percents or if it was mon_ to hav
that column become money i would appreciate any help or other ideas o
how to do this..

--
Kevin Willhoi
-----------------------------------------------------------------------
Kevin Willhoit's Profile: http://www.excelforum.com/member.php...fo&userid=2441
View this thread: http://www.excelforum.com/showthread.php?threadid=38348