Thread
:
loop
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
loop
Looping will be slower than FIND. Look in the vba help. If more than one
then use FINDNEXT.
--
Don Guillett
SalesAid Software
wrote in message
oups.com...
Somewhere in column F i have the value "Production". It could be in
F100 or F157. It is not known.
My cursor is in cell G7. I am using activecell.offset(1,0).select to
scroll downwards. I want to move my cursor in column G only till the
row where the cell value in column F is "Production" what would be the
syntax?
something like While Not Cells(row, 6).Value = "Production"
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett