Toggle Font Style Macro
 

I'm not looking to save and restore the background color of th
selection. I'm looking to save and restore the font STYLE.

So, if the font style were red with italics, I want to save and restor
that. If it were blue and bold size 15, I want to save and restor
that.

Does anyone know a function that returns the current selection's fon
style? So, is there a function for which I could do this:

dim myVariable = returnStyleFunction()

??????

--
GK8053
-----------------------------------------------------------------------
GK80535's Profile: http://www.excelforum.com/member.php...fo&userid=1546
View this thread: http://www.excelforum.com/showthread.php?threadid=27213

Toggle Font Style Macro
 

Hi
two ways:
1.Temporary variables
- either store ALL different font styles in temporay variables
- restore property by property afterwards
- saving these information can be done in the same way as I showed with
the background color :-)

2. Use a hidden sheet or a helper cell (e.g. cell IV1) where you copy
your formats with pastespecial and restore it from there. Drawback:
this restores all format information


--
Regards
Frank Kabel
Frankfurt, Germany


GK80535 wrote:
I'm not looking to save and restore the background color of the
selection. I'm looking to save and restore the font STYLE.

So, if the font style were red with italics, I want to save and
restore that. If it were blue and bold size 15, I want to save and
restore that.

Does anyone know a function that returns the current selection's font
style? So, is there a function for which I could do this:

dim myVariable = returnStyleFunction()

???????