WorkSheetFunction.Text() Method

  • Thread starter Thread starter Mili
  • Start date Start date
M

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.
 
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)
 
Back
Top