ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Parse web data on worksheet (https://www.excelbanter.com/excel-programming/367772-parse-web-data-worksheet.html)

Max Bialystock[_2_]

Parse web data on worksheet
 
What's the most efficient way to find the one cell on a worksheet that
contains <p class="itemtitle"?

Is there a better way than using Cells.Find(What:="<p class=""itemtitle""",
after:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=
_
xlNext, MatchCase:=False, SearchFormat:=False).Activate




All times are GMT +1. The time now is 05:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com