Pasting 'Value Only' in Excel
Posted on 2011-10-17
I have a directive to write VBA to "past value only" if a user copies one cell and pastes it into another. The client doesn't want the first cell's formatting pasted into the second cell so the second cell becomes a currency instead of a percentage, and that sort of thing. Also, pasting values only will resolve the foreseeable problem of a user copying/pasting a formula, most likely wanting the formula's result, not the forumula itself, pasted into the second cell.
I know how to paste a Value Only manually, but I have no clue how to begin doing it with VBA.
Hope someone can help!