| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy range of cells with blanks then paste without blanks
I have a range of cells that have values in some cells and blank in others
(actually there is a formula in all cells, but if there is no value, the formula returns nothing but a blank cell). I want to copy that range of cells and paste it in a column without pasting the blank cells. So the copy range may be 40 cells, but the paste range may only be 15 or 20. How can I paste this into the destination cells leaving no blanks? Any help would be greatly appreciated. Thanks, Rob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy range of cells with blanks then paste without blanks
See your thread in Programming
-- Regards Ron de Bruin http://www.rondebruin.nl "justaguyfromky" wrote in message ... I have a range of cells that have values in some cells and blank in others (actually there is a formula in all cells, but if there is no value, the formula returns nothing but a blank cell). I want to copy that range of cells and paste it in a column without pasting the blank cells. So the copy range may be 40 cells, but the paste range may only be 15 or 20. How can I paste this into the destination cells leaving no blanks? Any help would be greatly appreciated. Thanks, Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't copy & paste - "merged cells must be identically sized" | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Copy formulae and paste to range with Office 2003 | Excel Discussion (Misc queries) | |||
| Copy range of cells omitting formulas that result in " " | Excel Discussion (Misc queries) | |||
| Copy cells into range of cells until cell change | Excel Worksheet Functions | |||
Linear Mode
