Thread: For Each Next Loop behaving in unexpected manner
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default For Each Next Loop behaving in unexpected manner
You need to add the line:

WS.select within the loop before the range select.

See my most recent post.

Tom
Reply With QuoteReply With Quote