simora
01-15-2010, 02:22 AM
I am trying to select and name a range so that I can compare it to another range.
For Each m In payrange
If m.Value <> "" Then
NewStuff = m.Offset(0, 1).Resize(1, 5)
NewStuff.Select
I thought that I was setting m.Offset(0, 1).Resize(1, 5)
as a Range, but when I go to select it to test it, I'm getting an error.
How do I set m.Offset(0, 1).Resize(1, 5) to a range called NewStuff, and what is the best format for comparing NewStuff to another named range?
If OldStuff <> NewStuff Then MsgBox "NOPE!" is not working.
Thanks
For Each m In payrange
If m.Value <> "" Then
NewStuff = m.Offset(0, 1).Resize(1, 5)
NewStuff.Select
I thought that I was setting m.Offset(0, 1).Resize(1, 5)
as a Range, but when I go to select it to test it, I'm getting an error.
How do I set m.Offset(0, 1).Resize(1, 5) to a range called NewStuff, and what is the best format for comparing NewStuff to another named range?
If OldStuff <> NewStuff Then MsgBox "NOPE!" is not working.
Thanks