View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Bialystock[_2_] Max Bialystock[_2_] is offline
external usenet poster
 
Posts: 31
Default 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