View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jjk jjk is offline
external usenet poster
 
Posts: 42
Default Invalid "format string" argument in Format fuction

Hi,

I was wondering if there is any way to check for invalid "format
string" argument in the Format function.
As far as I can see it accepts all string combinations. Is there any
exception handling or boounds check that I can place here.
I ask this because I have to wrap the format functionality and want to
watch out for any side effects.

Thanks,
Jayant

Ref from Help:

Format Function
Returns a Variant (String) containing an expression formatted according
to instructions contained in a format expression.

Syntax:
Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

expression - Required. Any valid expression.
format - Optional. A valid named or user-defined format expression.
firstdayofweek - Optional. A constant that specifies the first day of
the week.
firstweekofyear - Optional. A constant that specifies the first week of
the year.