Current Selection = Object

[whicks]

I'm trying to set a relative reference as an "object" in VBA.

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select

I want this to be my "Object"

Should I Say;

Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select = Object

?????

Or;

ActiveSheet.UsedRange.Select = Object

 

[JE McGimpsey]

I'm not sure I understand what you're doing, but possibly:

Dim obj As Object
Set obj = ActiveSheet.UsedRange

or, usually better:

Dim rng As Range
Set rng = ActiveSheet.UsedRange

 

[whicks]

That's it!!

You are a wise one - Thanks!