| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Select a range not equal to:
Want to use VBA to select and copy a range that includes only the cells not
returning: "". The formulas in the cells/range evaluated either calculate and return a value, or return a "" (from the formula) The cells returning "" are always at the bottom of the range, while the cells returning data are on top. Just want to highlight the results so as to copy them into another application. TIA for any ideas. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting a .Range to equal another .Range | Excel Programming | |||
| Select rows equal to filter and highlight row | Excel Programming | |||
| Macro to select a list of values greater than or equal to a value | Excel Programming | |||
| Select from List of names to equal a specific rate | Excel Worksheet Functions | |||
| How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
![Pete[_25_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
