Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range to array excluding null values
Hello,
Is there a way to create an array from a range with the formula (varArray = RangeAddress) but excluding empty cells in the range (ot any value) It can be done by looping, but I am looking for the quick formula way Thanks avi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range to array excluding null values
avi,
No need to use an array. You can directly address the cells of the range using: Dim mcC As Range For Each myC In Range("D2:D16").SpecialCells(xlCellTypeConstants, 23) 'whatever you want here Next myC -- HTH, Bernie MS Excel MVP "avi" wrote in message ... Hello, Is there a way to create an array from a range with the formula (varArray = RangeAddress) but excluding empty cells in the range (ot any value) It can be done by looping, but I am looking for the quick formula way Thanks avi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range to array excluding null values
Thanks but I really need it as an array for the rest of my application
Avi |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range to array excluding null values
Avi,
Then you will need to loop through the cells as shown and assign the values to the array, after using redim on the array to set the size. Bernie "avi" wrote in message ... Thanks but I really need it as an array for the rest of my application Avi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Min excluding zero values, without an array fomrula | Excel Worksheet Functions | |||
How to return an array of values that are not zero/Null | Excel Discussion (Misc queries) | |||
How to return an array of values that are not zero/Null | Excel Discussion (Misc queries) | |||
Array keeps returning Null Values | Excel Programming | |||
Excluding NULL values in an Excel List | Excel Programming |