View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lloyd Lloyd is offline
external usenet poster
 
Posts: 1
Default For Each Sheet in Workbook

I need to check the same range.value in each sheet in my workbook.
Dim Sh As Object
Sh=Worksheet
For Each Sh in Workbook
But VBA asks for an Object, apparently not explicit enough. What code do
I need to check the same range.value on each worksheet??
TY
Lloyd


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!