View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dick Watson Dick Watson is offline
external usenet poster
 
Posts: 18
Default Iterating on several Cells within a Row

That did it. Thanks!

"Jacob Skaria" wrote in message
...
Change the loop within to

For Each mycell In Range(myrow.Cells(, ColY), myrow.Cells(, ColZ))
MsgBox mycell.Address
Next

If this post helps click Yes