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

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~