View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Loop down, then across

I don't quit get the range you want to work on, but I think you want
something like this:

Dim c As Range

For Each c In Range(Cells(4, 1), Cells(10, 25))
If c.Value = "x" Then
c.Value = Cells(3, c.Column)
End If
Next

RBS


"Bettergains" wrote in message
...
Hello:

A not so difficult question. I want to loop down rows, query the cell,
then
paste in a value (text from a fixed cell), and when this is done, start
over
in the next column. Something like this:

Range = R4c1: R4:c25
Loop down C1
If cell.text = "x" Then
cell.value = $R3Cy
Else
Next Row

Next Column

Thanks, G~