Can you dimension Range more than 1 way

[Patrick C. Simonds]

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)

 

[Bob Phillips]

So do it, no problem with that.

What is the question?

 

[Alan]

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)

Just leave out the 2nd Dim statement