Hi Hari,

They way I chuck stuff into Excel cells is to use the Range object.....

Code:
Dim liRow As Index
Dim lsCol As String

    lsCol = "A"
    For liRow = 1 To 10
        loWorksheet.Range(lsCol & liRow).Value = "This is row No. " & liRow
    Next
I cycle through (not literally as a road bike tends to find the excel surface too bumpy unless the gridlines are turned off!). As I wuz saying.... the cols are cycled through too, in some cases, using a quick algorithm to convert a number to column. With the Range object you can use the regular Excel notation to place the same data in multiple cells ("A1:C3" etc)