View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon Turner Jon Turner is offline
external usenet poster
 
Posts: 7
Default Why does this keep blowing chunks

Dim oUsedRange as Excel.Range
Dim oRange as Excel.Range

oUsedRange = WorkSheets("Employees").UsedRange
For each oRange in oUsedRange <-- Blows up here with member not
found

Next


P.S. I'm using VB.NET so there is no SET statement

Many Thanks in Advance