| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Copy, Paste Special macro
I need a macro button that will, on selection, evaluate if a cell from A39:A79 contains the text "Not Locked" and then will change all the corresponding formulas in those rows for columns B:I (B39:I79) into text (i.e. Their formula values: Copy Paste Special Paste Values). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for Edit/Copy/Paste Special | Excel Worksheet Functions | |||
| Copy & Paste Special Macro | Excel Discussion (Misc queries) | |||
| Copy Paste Special Macro | Excel Discussion (Misc queries) | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
| Need help with creating a special copy and paste macro | Excel Programming | |||
Threaded Mode
