Current Selection = Object

  • Thread starter Thread starter whicks
  • Start date Start date
W

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
 
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
 
Back
Top