Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
false blanks
Hi people,
I made a copy/paste special values from one sheet (formulas) to another. These formulas give me either a numeric value or blank ("") cell. However, the blanks that I copied/pasted are in fact "false blanks": if I use xlDirection, it goes to the very end of the pasted range, even if in between the cells are equal to "". Also, if I check the "false blank" cells with the =ISBLANK(), it gives me "FALSE". Do you know how to convert these "false blanks" to the normal blanks? (I know I can do it manually by going through the range and pressing "delete" key where needed, but I would rather look for a VBA solution, if it exists...) Your help would be much appreciated, Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP using FALSE returning blanks and #N/A | Excel Worksheet Functions | |||
Sumproduct copying blanks or how to insert zero into blanks | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
True Or False, no matter what... it still displays the false statement | Excel Programming |