Write in Excel

[Anu]

Hi,

Some one has told me to use "iNewcolumn=xlSheet.UsedRange.Columns.Count + 1"
this for adding the data in the new cloumn of same excel but it does not work from my side.

Thanks For urs prompt reply................
Regards,
Anu

---

Hi Saket,

I have tried the same code given by you..........
It is not adding the value to the next row.
The code given by you is below:

Code:

nRow = xlSheet.UsedRange
For i = 1 To CountOfRows
CustomerName=Browser("Meghalaya Directory Search").Page("Meghalaya Directory Search_3").WebTable("DataTable").WebTable("Table").GetCellData(i,3)
Address=Browser("Meghalaya Directory Search").Page("Meghalaya Directory Search_3").WebTable("DataTable").WebTable("Table").GetCellData(i,4)
nRow = nRow + 1
xlSheet.Rows(nRow).Columns(iCol).Value =CustomerName
xlSheet.Rows(nRow).Columns(iCol + 1).Value =Address
iNewcolumn=xlSheet.UsedRange.Columns.Count + 1

Next

Waiting for response.........
Regards,
Anu

---

Hi Saket,

Your question : Do you execute this everytime a new link clicked?

Answer: Please elaborate it.........

Regards,
Anu