| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quickest way to copy then Paste Special-Values in place?
All -
I'm cycling through a large range (~25x5300 cells) and setting .formula = .value to accomplish paste-special-values. There has to be a quicker way to copy and paste in place. When I repeat the macro recoder code, it somehow screws up in the spreadsheet, and I get ghost cells on my screen--cells overlaying cells that aren't really there. Anyway, - what's the best way to do this? ....best, Hash |
| 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 for a whole spreadsheet ? | Excel Discussion (Misc queries) | |||
| More efficient method to copy-paste values in place? | Excel Programming | |||
| Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming | |||
Threaded Mode
