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

N

netx

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
 
R

Ron de Bruin

Hi

Maybe you can use ClearContents instead

If not post back and I give you a example
 
Top