Copying an entire row of formulas

L

Lazer

How do I copy all *forumlas* (without values) in row 10, for example, to
row 20?

In other words, if the forumla for cell W10 is "=+S10+U10", then the
when I copy the entire row of formulas to row 20, the formula for W20
should be "=+S20+U20", *not* "=S10+U10"

Thanks!
Eliezer
 
G

Guest

Turn on the macro recorder
Select row 10
select copy
go to row 20 and place cursor in far left cell of row
select paste special formulas
turn off recorder
go to macro editor and see the code

Glen
 
L

Lazer

I did that but it kept copying over the numbers. In the end, I figure
this out:

For columnIterator = 1 To Columns("EI" & ":" & "EI").Column
If Cells(10, columnIterator).HasFormula Then
Cells(currentRow, columnIterator).FormulaR1C1
Cells(10, columnIterator).FormulaR1C1
End If
Next

Thanks!
Elieze
 
Top