View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hank[_3_] Hank[_3_] is offline
external usenet poster
 
Posts: 2
Default VBA: How to iterate through each cell of one specific row

This seems like a simple task but I can't find anything in
the docs or Google.

How, using VBA, can I iterate through each used cell of a
specific row? For instance perform a test on each cell of
row 2?

I tried this, but it seems to select every cell of the
whole sheet:

For Each cell In ActiveSheet.UsedRange.Rows(2)


Thanks.