| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select only cells containing values within named range
I have data in 5 columns and a maximum of 12 rows. This is a named range.
Rows will always be complete with data in each column but some rows at the top and/or bottom of the range will contain formulas resulting in no value (""). I need to be able to select the rows within the named range that result in values only, in able to paste them as values elsewhere within the spreadsheet. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Select Specific Cells in a Range | Excel Programming | |||
| Macro €“ select all cells in current range | Excel Discussion (Misc queries) | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| Select cells based on named Range and a column heading | Excel Programming | |||
| using cell values to select range of cells | Excel Programming | |||
Threaded Mode
