| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 dimension chart | Charts and Charting in Excel | |||
| Setting Range value using a single dimension array | Excel Programming | |||
| Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
| Put values into excel range from single dimension array | Excel Programming | |||
| Array transfer - 1 dimension v. 2 dimension | Excel Programming | |||
Linear Mode
