Hi Udhay,
By using usedrange object you can find the keyword.
Set fndObj=shtObj.UsedRange(A:A).Find("keyword")
rowNum=fndObj.row
colNum=fndObj.column
shtObj.Cells(rowNum,colNum)="Pass/Fail"
I think it helps you.
On Tue, Jun 5, 2012 at 12:56 PM, udhaya kumar <[email protected]>wrote:
> Hi All,
>
> i have to find particular keyword in excel and then i have
> to put pass/Fail in particular column cells. Please help me.
>
>
> Thank You,
> Udhay
>
> --
> You received this message because you are subscribed to the Google
> "QTP - HP Quick Test Professional - Automated Software Testing"
> group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/MercuryQTP?hl=en
>
--
Thanks and Reagards
Santhosh G
+918007850250
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
