Show formating

[Anax]

Hello,

I can find a way to set any formatting for a particular cell but I cannot find a way to check the formatting. To make it simpler, I want to check if the text in cell is bold and if it is aligned on the right side.
Any suggestions?

Thanks in advance

 

[Smitty]

This may sound stupid, but have you tried entering anything in it?

You can goto Format-->Cells and check each property, where the current setting will be indicated.

Hope that helps,

Smitty

 

[Anax]

I forgot to mention that this is part of VBA code.
The code to set range A1:A5 bold is:

Worksheets("Sheet1").Range("A1:A5").Font.Bold = True

What about if I want to check if A1:A5 is bold?

 

[Smitty]

<font face=tahoma><SPAN style="color:#00007F">Sub</SPAN> foo()
    <SPAN style="color:#00007F">Dim</SPAN> c <SPAN style="color:#00007F">As</SPAN> Range
        <SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> c <SPAN style="color:#00007F">In</SPAN> [A1:A5]
            <SPAN style="color:#00007F">If</SPAN> c.Font.Bold = <SPAN style="color:#00007F">True</SPAN> <SPAN style="color:#00007F">Then</SPAN> MsgBox "Bold"
        <SPAN style="color:#00007F">Next</SPAN> c
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

That's just a test...Not real practical.

Can you give some more detail as to what you're trying to accomplish?

Maybe post your code and an explanation of what you want it to do.

Smitty

 

[Anax]

This works!

Thank you very much