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!
Sub select_and_count()
'
' select_and_count Macro
'
'
Dim rngRange As Range
Dim lngCnt As Long
'Range(Selection, Selection.End(xlDown)).Select
Set rngRange = Range(Selection, Selection.End(xlDown)).Select
lngCnt = rngRange.Count
MsgBox lngCnt
End Sub
Bookmarks