[dba-Tech] Assign current selection to Range object

Thanks Andy -- that's it. I should pin this up someplace. I don't use it 
frequently, but when I do, I can never remember it! ;(

Function CountRangeProperties()
  Dim rg As Range
  Set rg = Application.Selection
  Debug.Print rg.Address
End Function

Susan H.


> Hi Susan
>
> Not sure but does the Selection property help? As in Application.Selection
> which, according to Help, returns you a Range object if that's what's
> selected.