Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array filling: cell addresses
Hello everybody,
I'm trying to fill an array with the cell addresses of several separately selected cells. This is what I have so far: ........ Option Explicit Sub test() Dim cell As Range Dim CellAdresses() As Variant For Each cell In Selection CellAdresses(cell) = cell.Address Next cell End Sub ...... Doing this gets me error number 9 Subscript out of range. It's propably a simple thing I'm overlooking. Please help. Peter. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drag-filling a formula Array | Excel Discussion (Misc queries) | |||
help with filling in an array formula | Excel Discussion (Misc queries) | |||
Filling a List Box in Excel from an Array | Excel Discussion (Misc queries) | |||
Filling excel entire row/column instead of single cell from an array | Excel Worksheet Functions | |||
Filling an array with data | Excel Worksheet Functions |