View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E. Charlotte E. is offline
external usenet poster
 
Posts: 45
Default Why do I get an error in this code???

Why do I get an error in the third line of this little code:

Dim WS As Worksheet
Dim WB As Workbook

WB = ThisWorkbook
For Each WS In WB.Worksheets


????