How to sent for cell: font size=7,text format in VBA
 

I am losting "font size" and "text format" in Cells
after I do .Range().Clear
I wonder how to set in VBA:
- font size for cell
- formatting "text" for cell
Excel XP.

I am not sure about translation of above because I use Polish version of
Excel.

Thanks for help,

Mark

Hi

Maybe you can use ClearContents instead

If not post back and I give you a example

--
Regards Ron de Bruin
http://www.rondebruin.nl


"netx" wrote in message ...
I am losting "font size" and "text format" in Cells
after I do .Range().Clear
I wonder how to set in VBA:
- font size for cell
- formatting "text" for cell
Excel XP.

I am not sure about translation of above because I use Polish version of
Excel.

Thanks for help,

Mark