Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2017, 08:57 AM
cspitser cspitser is offline change the definition of range name Windows 7 64bit change the definition of range name Office 2013
Novice
change the definition of range name
 
Join Date: Mar 2017
Posts: 2
cspitser is on a distinguished road
Default change the definition of range name


I have a database with a range called "posted date". I want to add cells to the botom of that range and then change the definition of the range to include the new cells. How do I do this?
Reply With Quote
  #2  
Old 03-29-2017, 10:36 AM
gebobs gebobs is offline change the definition of range name Windows 7 64bit change the definition of range name Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

The most robust way would be to use the Format as Table functionality. Each column is implicitly identified as a range per the column header and the reference is automatically updated when records are added. If you would like help setting this up, attach your workbook here.

Otherwise, you can manually update the reference of named ranges with Formula:Name Manager.
Reply With Quote
  #3  
Old 03-29-2017, 01:30 PM
cspitser cspitser is offline change the definition of range name Windows 7 64bit change the definition of range name Office 2013
Novice
change the definition of range name
 
Join Date: Mar 2017
Posts: 2
cspitser is on a distinguished road
Default

OK, Thanks for the offer but I cannot attach the file. It is slsx
Reply With Quote
Reply

Tags
range formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Acronym lister and definition checker for Microsoft Word gwez Word VBA 1 06-13-2015 04:00 AM
change the definition of range name Lastrow definition problem YounesB3 Excel Programming 1 09-26-2012 10:08 PM
change the definition of range name definition of work column ketanco Project 9 05-31-2012 05:15 PM
font in style definition trashed eNGiNe Word 1 03-30-2012 05:03 AM
Dumping styles definition gouletp Word 3 09-06-2011 10:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft