Thread
:
How to use function CELL(Infotyp;Ref) in VBA?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
How to use function CELL(Infotyp;Ref) in VBA?
Not all worksheetfunctions are available in VBA. This appears to be one of
them.
Nothing else produces those categorizations. You can use
sFormat = ActiveCell.Numberformat
then parse the results to make your own determination.
--
Regards,
Tom Ogilvy
"Stefan Jauch" <Stefan
wrote in message
...
Hi.
I try to use the worksheet function CELL(Infotyp;Ref) in VBA to abtain the
format info of a cell. But in VBA I can't find this function (it is not
included in the Application.WorksheetFunction object!)
How can I use CELL(..) in VBA?
Is there any other way to obatin the format info that is given by
CELL("Format", ...), i.e. "S" for standard, "F2" for "0,00", "P0" for "0%"
and so on...)?
Thanks in advance,
Stefan Jauch
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy