| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding range values to array
what would be some options for adding only values in this range that are not
blank to the array? arr = .Range("B12:B" & lRow).Value -- Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding range values to array
this is what i have right now:
For k = 12 To 33 If .Range("B" & k).Value "" Then l = l + 1 ReDim Preserve arr(1 To l) arr(l) = .Range("B" & k).Value End If Next -- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... what would be some options for adding only values in this range that are not blank to the array? arr = .Range("B12:B" & lRow).Value -- Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
adding range values to array
no need to reply, i did something different using 2 arrays.
-- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... what would be some options for adding only values in this range that are not blank to the array? arr = .Range("B12:B" & lRow).Value -- Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| range values in an array? | Excel Programming | |||
| Adding or Deleteing Rows in a Range with an Array formula | Excel Programming | |||
| Adding values to 2-dim array | Excel Programming | |||
| Array of Values from Worksheet Range - What does it 'look' like? | Excel Programming | |||
| Adding range to array, keep formatting | Excel Programming | |||
Hybrid Mode
