Setting A Range variable That is Assigned Using xlDown (relative reference?) as the range

[catbeasy]

ok, so I have code per below that I want to assign a range variable where the range is set using xlDown (is that considered 'relative reference' without the offset stuff?). Trouble is when I try to do that I get an error saying 'Object Required' (Run Time Error 424).

I do have the 'Set' keyword as you can see, so I'm guessing this has something to do with using a relative reference(?) as the assigning piece of setting this range?

Anyway, then I want to Count how much I get returned.

Thanks for any help!

Please Login or Register  to view this content.

[6StringJazzer]

You are trying to do two different things on the same line of code. Remove the .Select:

Please Login or Register  to view this content.

[catbeasy]

Cool, thanks so much!