Thread: Loop until cell is empty
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leonardo Leonardo is offline
external usenet poster
  
Posts: 11
Default Loop until cell is empty
Have you tried:

While ActiveCell < Empty

Your_routine ' Enter your code, looking for desired string and deciding

' if it must be replaced or not

Activecell.Offset(1,0).Select

Wend

Best regards.

Reply With QuoteReply With Quote