| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GeFormat function in Office 97
Can anyone confirm whether this function will operate
under Office 97 - i have a workbook that stalls if run on O97 - no error message - but runs on a colleagues O2000. This function is used during the phase in question... Function GetFormat(Cell As Range) As String GetFormat = Cell.NumberFormat End Function many thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
GeFormat function in Office 97
It worked for me in Excel 97.
-- Regards, Tom Ogilvy "Mike" wrote in message ... Can anyone confirm whether this function will operate under Office 97 - i have a workbook that stalls if run on O97 - no error message - but runs on a colleagues O2000. This function is used during the phase in question... Function GetFormat(Cell As Range) As String GetFormat = Cell.NumberFormat End Function many thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
GeFormat function in Office 97
are you sure the cell is: a single cell or a merged cell or a range of cells with exactly the same numberformats? to solve try: cell(1).numberformat -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Mike wrote : Can anyone confirm whether this function will operate under Office 97 - i have a workbook that stalls if run on O97 - no error message - but runs on a colleagues O2000. This function is used during the phase in question... Function GetFormat(Cell As Range) As String GetFormat = Cell.NumberFormat End Function many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is spellnumber function no more available in MS office 2007? | Excel Discussion (Misc queries) | |||
| INDIRECT function in Office 2007 | Excel Worksheet Functions | |||
| Help...Office Excel 2003 IF Function | Excel Worksheet Functions | |||
| function wizard on office 2003 | Excel Worksheet Functions | |||
| TIR.NO.PER function, where do i found it in Office 2003??? | Excel Worksheet Functions | |||
Hybrid Mode
