Always nice to post your code for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cat" wrote in message
...
In the new version of excel, when I record a macro to change font colors,
cell borders, border fills, etc, everything records correctly. But then
when
I use the macro, it doesn't change the formatting like I recorded. I used
to
do this in the old version of excel with no issues. Can anyone help?

Thanks,