Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Paste Special Values
Hello again! I have a formula IF(A1=2,"",A2) if there is a 2 in A1 and I cop the cell and then paste-special-values to another cell it leaves a ' i the cell which is causing me problems when I use an end-up or down t select the range. I only want to select cells that have data in the not '. Is there a way to leave a cell "truely blank" when using formula in it? or! Is there a way I can delete the ' s only from range and leave the rest of the data to be selected? The goal here is to take the data produced from a range of formula (not all rows produce data each time) and copy it to a list that can b added to by the same process. In other words the list just keeps gettin longer (no empty rows) each time data is "Posted " from the range o formulas. I'm sure there is a more efficient way to do it than my "cop paste-special-values and sort" method. As always, help is greatly appriciated. Thanks! -- Brian Matlac ----------------------------------------------------------------------- Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350 View this thread: http://www.excelforum.com/showthread.php?threadid=47682 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Paste Special Values
Instead of using paste=Special, Values use
ActiveCell.Formula = ActiveCell.Value -- Regards, Tom Ogilvy "Brian Matlack" wrote in message news:Brian.Matlack.1x20ec_1129565118.9961@excelfor um-nospam.com... Hello again! I have a formula IF(A1=2,"",A2) if there is a 2 in A1 and I copy the cell and then paste-special-values to another cell it leaves a ' in the cell which is causing me problems when I use an end-up or down to select the range. I only want to select cells that have data in them not '. Is there a way to leave a cell "truely blank" when using a formula in it? or! Is there a way I can delete the ' s only from a range and leave the rest of the data to be selected? The goal here is to take the data produced from a range of formulas (not all rows produce data each time) and copy it to a list that can be added to by the same process. In other words the list just keeps getting longer (no empty rows) each time data is "Posted " from the range of formulas. I'm sure there is a more efficient way to do it than my "copy paste-special-values and sort" method. As always, help is greatly appriciated. Thanks!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=476826 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Of Values After A Copy And Paste Special: Why ? | Excel Discussion (Misc queries) | |||
Copy Values only without Paste Special | Excel Discussion (Misc queries) | |||
copy paste special values | Excel Programming | |||
Copy and paste special, values not working | Excel Programming | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |