Like CELL(), but for text properties?

  • Thread starter Thread starter Del Cotter
  • Start date Start date
D

Del Cotter

I have a list in Excel 2000, formatted in the following way

Header1 (Bold, left aligned)
Subhead (indented)
Subhead (indented)
Blank line
Header2 (Bold, left aligned)
Subhead (indented)
etc.

I want to detect a text formatting property of the header cells, in a
similar way to the number and alignment properties available in the
CELL() function, but alignment isn't good enough. Number formatting is
also out, because I want untrained users to use this list, and I need
them to be able to see what they're doing.

Detecting bold-formatted cells would be ideal.
 
Del Cotter said:
I want to detect a text formatting property of the header cells, in a
similar way to the number and alignment properties available in the
CELL() function, but alignment isn't good enough. . . .
Click to expand...
....

Unclear exactly what you want, but you could try importing the VBA file
contained in

ftp://members.aol.com/hrlngrv/ExtCell.zip

in the VB Editor, and using the ExtCell function it contains. It works
similar to CELL, but it provides access to most Range class properties.
 
Back
Top