View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lazer[_4_] Lazer[_4_] is offline
external usenet poster
 
Posts: 1
Default Copying an entire row of formulas

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/