Thread: Calling all VBA Genius's
View Single Post
Old Oct 6, 2009 | 11:40 PM
  #4  
cjwood555's Avatar
cjwood555
Advanced PassionFord User
 
Joined: Feb 2005
Posts: 2,090
Likes: 0
From: Solihull
Default
Have you got more than one workbook open? could need modifying to:

For Each WS In ThisWorkbook.Worksheets or ActiveWorkbook.Worksheets

?
Reply
0