NameAsCell - missing in XLSReadWriteII 5?

[kayeng]

Hi,

In XLSReadWriteII 4, I was able to write this code:

Code: Select all

   XLS.NameAsCell["MyCellName'].NumberFormat := '[$£-809]#,##0.00;[RED]-[$£-809]#,##0.00'

In XLSReadWriteII 5, how do I obtain the cell by name and then apply the required format?

Thanks for your help.

Cheers,
Kaye.

[larsa]

Hello

The NamaAsCell property is not available in version 5. Please study the NamedCells sample for info on using named cells.