Can you dimension Range more than 1 way
 

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)

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)