Toggle Macro
Tom was the only one to give you the format as well, but the code
Range("D33").value = .08
Range("D33").Numberformat = "0%"
can be combined with
Range("D33").value = "8%"
Excel does the rest.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Michael" wrote in message
...
I'm having trouble learning Macros. I need to toggle a single cell (d33)
between a value of 8% and blank.
ALSO, I'd love a better site for help topic. MS really dropped the ball
on this topic.
Thanks,
Michael
---
|