VBA..Type Mismatch when subtracting 2 Percentages

[ilcaa]

i have 2 different functions, each produces a number the is formatted as a percent "0.0%"

i am trying to run a sub that subtracts these 2 percentages, but it returns a Type Mismatch error. How can i correct this.
I need to have the 2 functions formatted as "0.0%"

 

[soccerkingpilot]

With regards to formatting as a percentage before running the subtraction operation, see this thread:
http://msdn.microsoft.com/en-us/library/aa164238(v=office.10).aspx

-Austin

 

[ilcaa]

thanks Austin, but i changed it from format(a,"0.0%") to FormatPercent(a) and I still get the same Type MisMatch error message when i subtract the 2 percentages...

 

[soccerkingpilot]

Can you post your code? That will help with troubleshooting

Thanks.