Thread: Auto add a list cell if the last list cell is filled
View Single Post
 
Old 07-31-2012, 08:40 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
Hi Eli,

It would be easier if you either:
a) defined the largest possible range that will be required; or
b) mark the last row in the range to indicate it shouldn't be used, then insert rows above that row as needed; or
c) assign a name to the range, use the range name in the formula and redifine the named range as need be
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote