ExcelObj.Rows("1:1").Select
On Fri, Dec 6, 2013 at 10:23 AM, Neville Palmer
<[email protected]>wrote:
> I know the first cell in the range which will be "C2" but the last cell
> could be anything so I need to search for it, then I want to highlight the
> range for deletion. I'm able to get the last row and last column number
> which on the practice sheet is row 125 and Column 25. The row number could
> change but the column number is a constant.
>
> Dim oExcel, oWB, oSheet, sValue, oVisible,
>
> Set oExcel=CreateObject("Excel.Application")
> Set oWB=oExcel.Workbooks.Open("C:\temp\*&^%$")
>
> Set oSheet=oWB.Sheets("*&^%$")
> oExcel.Visible=TRUE
>
> LastRow = oSheet.UsedRange.Rows.Count
> LastCol = oSheet.UsedRange.Columns.Count
>
> Any help on how to select these cells would be very welcome
>
> TIA
>
> --
> --
> 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
>
> ---
> You received this message because you are subscribed to the Google Groups
> "QTP - HP Quick Test Professional - Automated Software Testing" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
Regards,
Ganesh Muralidharan
'God Never Forgets'
--
--
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
---
You received this message because you are subscribed to the Google Groups "QTP
- HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
