| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
repeat macro formula to all cells
i have data spread across 6 columns and 300 rows. I have written a macro that
moves data from row 3 to row 1. I want to repeat the macro so that it performs the move for row 6 to row 4, row 9 to line 7 etc. Do i have to paste and copy the macro or is there a way of writing it only once so that it repeats till the end of the range? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) | |||
| My formula screws up other reference cells... | Excel Discussion (Misc queries) | |||
| Cells displays formula, not results | Excel Worksheet Functions | |||
| to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions | |||
| Macro Formula revision? | Excel Worksheet Functions | |||
Threaded Mode
