Current Selection = Object

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

whicks - 07 Nov 2007 15:50 GMT

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

Reply to this Message

JE McGimpsey - 07 Nov 2007 16:12 GMT

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

> I'm trying to set a relative reference as an "object" in VBA.
>
[quoted text clipped - 11 lines]
>
> ActiveSheet.UsedRange.Select = Object

Reply to this Message

whicks - 07 Nov 2007 17:09 GMT

That's it!!

You are a wise one - Thanks!

Reply to this Message

Rate this thread: