Invalid procedure call or argument

[Uma]

Hi,
In my Excel sheet I have 3 rows.Up to three rows my script is woking fine with the following for loop

Code:

For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
.......


Next

After the 3 rd row it is not coming out and it is igoing into the for loop again and started giving the following error,
Invalid procedure call or argument
Line (166):

Code:

"Browser("name:=.*").Page("title:=.*").WebList("name:=SearchType","location:=0").Select "SearchType"

Why?
Any help?
Thanks,
Uma

---

Hi
I have 3 rows in my excel sheet and my script is working for all the 3 rows using the following for loop,

Code:

For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
...............................
Next

After I checked the third row,it does not coming out,
it goes inside again and it gives some error,
Invalid procedure call or argument

Why?
Any help?
Thanks,
Uma

---

Hi,
In my Excel sheet I have 3 rows.Up to three rows my script is woking fine with the following for loop
For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
.......


Next

After the 3 rd row it is not coming out and it is igoing into the for loop again and started giving the following error,
Invalid procedure call or argument

Code:

Line (166): "Browser("name:=.*").Page("title:=.*").WebList("name:=SearchType","location:=0").Select "SearchType"

Why?
Any help?
Thanks,
Uma

[vIns]

Hi,

Does this "xlWrksht.UsedRange.Rows.Count" return 3?

[Ankesh]

plz post ur code.

[Uma]

Ankesh,
Thanks for asking,

It is working,I gave 3 for loops according to the worksheet,like this,

Code:

For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
.......
Next
For intRow = intStartRow to xlWrksht1.UsedRange.Rows.Count

.....
Next
For intRow = intStartRow to xlWrksht2.UsedRange.Rows.Count
......
Next

Thank you
Uma

[Uma]

Hi,
It is solved,I gave 3 for loops according to its sheet.

For intRow = intStartRow to xlWrksht.UsedRange.Rows.Count
Next

For intRow = intStartRow to xlWrksht1.UsedRange.Rows.Count
Next
......

Thank you
Uma

[Uma]

Hi Ankesh,
It was working ,Now it is started giving same error,
It shows error in the following line

Code:

Browser("name:="&result,"application version:=internet explorer 7").Page("title:=Re.*", "index:=0").WebList("name:= SearchType","html id:=Select1").Select SearchType1

Thank you
Uma