Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to use "if" logical argument to format/copy some pic. in cell | Excel Worksheet Functions | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
Format a column wihtout using "Format-Cells-Number-category-etc" | Excel Worksheet Functions | |||
Changing format of column from "general" to "currency" | Excel Programming | |||
Convert "Month" to "MonthName" format from db to PivotTable | Excel Programming |