| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range object without blank cells
Hi
How do i call the following code, but not get back any empty cells Set tempRange = Worksheets("Step Chart").Range("ColumnMapping") As it returns all the cells, even if they are blank/empty... I can return just the empty cells by using ..SpecialCells(xlCellTypeBlanks) What is the reverse of this? As in the end i want an array without any empty values, if there is any in the named range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Named Range with blank cells | Excel Discussion (Misc queries) | |||
| Generating truly blank cells | Excel Worksheet Functions | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| Match function...random search? | Excel Worksheet Functions | |||
Threaded Mode
