View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default why doesn't macro record text color, or patterns?

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,