| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving range to array
Hi,
I can move a 2D array to a range but how do I move a selected range to a 2D array? Dim MyGrid() As String Range("A9").Select Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select MyGrid = Selection.Text (or) MyGrid = Range("B2:D5").Text Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving range? | Excel Discussion (Misc queries) | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| sum with moving range | Excel Discussion (Misc queries) | |||
| RTD w/Array Formula fails when moving to new PC | Excel Programming | |||
| Moving Array formulas from spreadsheet to VBA | Excel Programming | |||
Threaded Mode
