| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a Cell with a macro
Thanks Michael. That works perfectly
"michael.beckinsale" wrote: Hi Otto, Try replacing each bit of your code that looks like this: Range("M19:M58").Interior.ColorIndex = 4 Selection.AutoFill Destination:=Range("M18:M58"), Type:=xlFillDefault Range("M18:M58").Select With this Range("M18").Copy Destination:= Range("M19:M58") This will copy all of the properties of 'M18' to 'M19:M58' and the because you are not selecting ranges the code is more efficient. HTH Michael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to search a text in a cell and copy the row to another set of cell | Excel Programming | |||
| Creating Macro to copy information from cell into another cell using Add Comments | Excel Programming | |||
| Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
| macro to copy & paste cell data into another cell | Excel Programming | |||
| Writing a macro to copy first cell down until next cell has data | Excel Programming | |||
Threaded Mode
