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

-----Original Message-----
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


---
Message posted from http://www.ExcelForum.com/

.