WorkSheetFunction.Text() Method

[Mili]

Hi,
Is it possible for any one to explain the other
methods available with Cells(row,col), and where I can
find them in MSDN.
I am using the following Code.
**********************************************************
CellValue = Application.WorksheetFunction.Text(Cells
(RowNdx, ColNdx).Value, Cells(RowNdx,
ColNdx).NumberFormat)
**********************************************************

Thanks

Mili.

 

[Dave Peterson]

Try taking a look at Range in VBA's help. You'll see the methods and properties
listed there.

And just for your example, you could use:

CellValue = cells(rowndx,colndx).text

or you could use VBA's Format function:

CellValue = Format(Cells(rowNdx, colNdx).Value, _
Cells(rowNdx, colNdx).NumberFormat)