View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Loop thru used rows in column


For Each cell in Range(Range("A4"), Range("A4").End(xlDown))

do something with cell
Next cell

--

HTH

Bob

"Gsurfdude" wrote in message
...
Hello,

I am fairly new to Excel VBA and I need to know how to loop through used
rows in a one column. In logic

for each row in column A starting @ A4 to A whatever

So I need to return values in A4-A whatever is used. I hope that makes
sense

Thanks!