| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Destination Format
Hello Wise ones,
I have multi-user workbook in which one sheet has ref # that user can past in 2nd sheet to pull various lookup data from 3rd hidden sheet. it is mostly cosmetic ( pet peeve ) that user doesn't past values only. is there a macro / way to only paste values and keep dest format in destination cell? border / font / color all being effected. thanks , Steven - Dallas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible to set "match destination format" as default in paste? | Excel Discussion (Misc queries) | |||
| Paste in "match destination format" macro code | Excel Discussion (Misc queries) | |||
| How to set a default paste option of "Match Destination Format" | Excel Discussion (Misc queries) | |||
| Format date in destination cell | Excel Worksheet Functions | |||
| Make "Match Destination Format" the default | Excel Discussion (Misc queries) | |||
Threaded Mode
