VBA Formatting of Formula Value

[griffj]

Hi

I have the following line in my VBA, ActiveSheet.Range("G206").Formula = "=(F206 - D206)/F206". What I am trying to achieve is format the output as a percent.

I have tried wrapping my code in Format() and I have also tried adding, .NumberFormat("Percent") on the end with no joy.

Do I have to declare the value and then apply the formatting?

Any help would be great.

 

[steve the fish]

Yes if you want the formula to be placed you then need to format the cell:

.NumberFormat = "0.00%"

for example.