Detecting Cell Format Using Named Formula

[KL]

Hi there,

About a year ago I found in the Internet a tutorial on how to create a
formula that would detect some of cell formats. It used some long and
complex functions and named formulas. Maybe somebody knows what I am taking
about. If yes, could you please point at the source web site as I seem to
have lost the link somehow.

Many thanks,
KL

 

[Kevin Stecyk]

KL,

I am making a wild guess, but I think you are referring the =Cell(info_type,
reference) function.

For example,

=Cell("format")

Look up Cell function in XL's help and there is plenty of informatin there.

Hope that helps.

Regards,
Kevin

 

[KL]

Hi Kevin,

Thanks for your reply. Your guess is very close, but not exactly it. However
it helped me to find an article that uses exactly the technique I was
talking about:
http://www.j-walk.com/ss/excel/usertips/tip045.htm
Unfortunately, Excel Help doesn't seem to provide info on the usage of the
function so I still need to find the tutorial. I think the named formula did
recognise things like bold, italic, etc. I tried to google David Hager, who
seems to be author, but found nothing. I wonder if John Walkenbach (whose
VBA book I am reading and re-reading constantly) can help.

Thanks a lot.
KL

 

[KL]

I actually found what I was looking for at this site, but the tutrial is
significantly reduced and there is no sample workbook:
http://www.j-walk.com/ss/excel/eee/eee009.txt
So I still need to find the values of the first argument of GET.CELL()

Regards,
KL

 

[KL]

I got it. The file called Arg2Name.zip is here.

KL

 

[Kevin Stecyk]

KL

Glad you my wild guess helped you in your hunt.

Regards,
Kevin