Jump to content

_Excel_RangeFind for a specific sheet


gcriaco
 Share

Recommended Posts

Example: Set parameter 3 to $oWorkbook.Sheets(5).UsedRange to search all cells on sheet 5.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

It works fine.

BTW, I commented the following two lines in the UDF to avoid errors:

    ;$aResult[$iIndex][1] = $oMatch.Name.Name
    ;$aResult[$iIndex][5] = $oMatch.Comment.Text
as other users posted in this forum. I thought you should know.

 

Many thanks for your help.

 

Have a good year ahead.

Peppe

Link to comment
Share on other sites

Glad it works now.
This is a known bug. I'm not sure if I will do a workaround or wait until the bug has been fixed :huh:

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

  • 1 year later...
On 12/31/2015 at 6:23 AM, water said:

Example: Set parameter 3 to $oWorkbook.Sheets(5).UsedRange to search all cells on sheet 5.

Erm, can you explain how this works in english? I have a workbook object $oWorkbook, I want to search in a sheet named "template" for the string "description". The problem I'm having is the help file is less than descriptive. 

Peram 3 is described as "A range object, an A1 range (string) or keyword Default to search all sheets of the workbook (default = keyword Default)" but I can't find anything about a1 range or range objects in the help file. The description of peram 4 is also lacking on what XLFindLookIn enumeration is and has no info about it.

I also want to note, most other _excel_range* functions were rewritten to use $oWorksheet instead of $oWorkbook, and the fact _Excel_RangeFind does not use worksheet seems like an oversight. Shouldn't _Excel_RangeFind be useable on a specific worksheet like the rest of the _excel_range functions? What about making it take workbook (to search whole book) or worksheet (to search specific sheet)?

Either way, I'm confused how to search only one sheet and don't understand the previous answer, could you clarify?

Edited by corgano

0x616e2069646561206973206c696b652061206d616e20776974686f7574206120626f64792c20746f206669676874206f6e6520697320746f206e657665722077696e2e2e2e2e

Link to comment
Share on other sites

1 hour ago, corgano said:

but I can't find anything about a1 range or range objects in the help file.

That's because the AutoIt help file describes the Excel UDF, not the basics of Microsoft Excel.
In the wiki you can find more information about how the UDF works.
 

1 hour ago, corgano said:

I also want to note, most other _excel_range* functions were rewritten to use $oWorksheet instead of $oWorkbook, and the fact _Excel_RangeFind does not use worksheet seems like an oversight.

Thats because you can specify to search some rows or columns (a range) as well, not just a whole sheet. So it isn't an oversight.

1 hour ago, corgano said:

Shouldn't _Excel_RangeFind be useable on a specific worksheet

Specify the sheet to be searched as described in post #2.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...