View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Smith Michael Smith is offline
external usenet poster
 
Posts: 77
Default For Each offset range

Please help! I need to "do stuff" if column I is greater than 0...but
this isn't working.

Dim ws1 As Worksheet
For Each row In ws1
If Range.Offset(0, 9).Text 0 Then
do stuff
End If
Next

Thanks!
Mike


*** Sent via Developersdex http://www.developersdex.com ***