searchresult Posted May 4, 2012 Posted May 4, 2012 Hi, I'm stuck with this problem for some time and have tried don't know how many combinations. So this is my problem: Let's say that there is data inside cells(column) from G5 to Row Count And i need to find something in that column. If it is found then i need to copy that row to a different workbook. But i don't know how to search for that data in the specified cell. $findData = "Something" $rowRange = $oExcel.ActiveSheet.UsedRange.Rows.Count Local $i = 1 For $i = 1 To $rowRange $oExcel.Cells.Find(.... $oExcel.Rows($oExcel.ActiveCell.Row).Select $oExcel.Selection.Copy #cs Here comes the past part It doesn't matter at this moment #ce Next
water Posted May 4, 2012 Posted May 4, 2012 You could use function _ExcelFindInRange() from the My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.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 (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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now