| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
beginnersproblem copy formulas to cells
Hello, I want to copy several formulas in a row to the cells beneath them.
I'm using the following code For i = 3 To 30 Step 3 intAantal = Range("A1").Value + 1 Range(Cells(2, i)).Copy Range(Cells(3, i), Cells(intAantal, i)).Select ActiveSheet.Paste Next i I get an error message at the line with the Copy text but I don't understand what I'm doing wrong. Can someone help me out. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy formulas from non-adjacent cells | Excel Discussion (Misc queries) | |||
| copy formulas over merged cells | Excel Discussion (Misc queries) | |||
| Skip cells and copy formulas | Excel Discussion (Misc queries) | |||
| Copy several cells with formulas as they are? | Excel Discussion (Misc queries) | |||
| How do I copy only cells with formulas in another row? | Excel Worksheet Functions | |||
Threaded Mode
