Thread: Loop through cells meeting conditions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Huyeote[_14_] Huyeote[_14_] is offline
external usenet poster
  
Posts: 1
Default Loop through cells meeting conditions

Hi guys,

Is there any quick way in VBA to code to loop through all cells in
given range meeting one or more user defined conditions? Th
Specialcells method doesn't provide input for user to define
condition. How to write concise code to do thing like.. (borrow Wher
from SQL)

For Each x in myRange Where x 0 And x.Offset(0,-1) ="A"
.....

Next x


Thanks,

Huyeot

--
Huyeot
-----------------------------------------------------------------------
Huyeote's Profile: http://www.excelforum.com/member.php...fo&userid=1389
View this thread: http://www.excelforum.com/showthread.php?threadid=47572

Reply With QuoteReply With Quote