Why does this keep blowing chunks

J

Jon Turner

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
 
C

Chip Pearson

Jon,

Your code should work as written. Try appending Cells to your
oUsedRange variable. E.g.,

For each oRange in oUsedRange.Cells


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
C

Chip Pearson

As the original poster indicated, he is writing in VB.NET, which
has no Set statement.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
J

Jon Turner

I appended Cells but still does the same. Any other suggestions ? TIA

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

Next
 
J

Jon Turner

Programmer Error. Problem fixed.

How do I go about querying an individual cell in the WorkSheet.Range.Cells
collection ?
I want to find out each cell's value and column name.

TIA
 
T

Tom Ogilvy

oRange.Value

oRange.column

Not sure what a column Name is, but using integers has always been
sufficient for me.
 
Top