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

  • Thread starter Thread starter netx
  • Start date Start date
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
 
Hi

Maybe you can use ClearContents instead

If not post back and I give you a example
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sent for cell: font size=7,text format in VBA 3
Conditionally formatting text and numbers differently 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Conditional Formatting Font Change 1
Question about conditional formatting of zeros in Excel 0
Font changed by Conditional Formatting 1
Conditional formatting in Excel 2007 - font choice grayed out 0
Is it possible to protect cell formatting in an unlocked cell? 2

Back
Top