| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array from range question
i am using this to populate an array
arr = .Range("B12:B" & lRow).Value then i use this to work with the array For x = LBound(arr) To UBound(arr) If arr(x, 1) "" Then the problem is when lrow = 12 (only 1 element in array), i get a type mismatch. how can i get around it? -- Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| array, range question | Excel Discussion (Misc queries) | |||
| copy one array formula to an array range | Excel Programming | |||
| Question about working with range array | Excel Programming | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
| Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Threaded Mode
