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

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()

???????