View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JF[_4_] JF[_4_] is offline
external usenet poster
 
Posts: 1
Default Trouble getting used to VBA

I am new to Visual basic and have made only a few
applications i was wondering if someone knew how to name a
range as a variable. The bottom part is where im having
the issue


Thanks

Jeff

Dim INS As Range

ActiveCell.Offset(0, 2).Select
Range(Selection, Selection.End(xlDown)).Select

' Trying to name the following range
INS = activeRange.Select

End Sub