You don't use Set in VB.NET


"keepITcool" wrote in message
...
Jon, Chip..

the crucial mistake is forgetting SET
SET oUsedRange = WorkSheets("Employees").UsedRange



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Chip Pearson" wrote:

Jon,

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

For each oRange in oUsedRange.Cells