explanation
On Oct 31, 12:42 pm, "Bob Phillips" wrote:
It is looping through N6:N31 a cell at a time, mycell points at the current
cell in each iteration of the loop.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"ssrvant" wrote in message
thank you.
ups.com...
Can someone please tell me what this function does. Especially the
"Cells(mycell.Row,4).value = ""
Secondly, what is the association between (mycell.Row, 4) and
Range(N6:N31)
For Each mycell In Range("N6:N31")
'' If mycell.Value n Then
'' Cells(mycell.Row, 4).Value = ""
'' Cells(mycell.Row, 5).Value = ""
'' End If
|