Howard Kaikow
12-28-2005, 01:43 AM
I am inserting stuff into some cells as follows:
shtExcel.Range(Cells(i, 1), Cells(i, 5)) = Split(strBuffer, vbTab)
Then, I am trying to change some of the cells to numeric format.
What do I need to use instead of the following?
shtExcel.Range(Cells(i, 2), Cells(i + j,3)).NumberFormat = "#,##0.00"
shtExcel.Range(Cells(i, 1), Cells(i, 5)) = Split(strBuffer, vbTab)
Then, I am trying to change some of the cells to numeric format.
What do I need to use instead of the following?
shtExcel.Range(Cells(i, 2), Cells(i + j,3)).NumberFormat = "#,##0.00"