View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Shaw[_4_] Simon Shaw[_4_] is offline
external usenet poster
 
Posts: 3
Default assigning worksheet variable

I want to set the variable ws similar to the For statement, but I want to set it for just the current active sheet.

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets

please help this is not working:

ws = ActiveSheets