View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Can you dimension Range more than 1 way

So do it, no problem with that.

What is the question?

--
__________________________________
HTH

Bob

"Patrick C. Simonds" wrote in message
...
In my routine I have the following Dim statement:

Dim mg As Range
Set mg = Range("Employees")

but I need to add the following in the same routine::

Dim rng
Set rng = Cells(ActiveCell.Row, 1)