Thread: [Solved] How to make cells shift down automatically
View Single Post
 
Old 01-21-2011, 03:53 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
If you want to have your formulae at the bootom of the range, the safest way is to have a 'boundary' row at each end of the range that has no values in it (eg just a string of '-' characters) and have your formulae include those 'boundary' rows. As you insert/delete rows, the formulae will automatically adjust, based on the new addresses of the boundary rows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote