Dynamic Named Range Chart Example

Rating: No reviews yet
Downloads: 7
Updated: Aug 16, 2010 by vikasbhandari2
Dev status: Planning Help Icon

Recommended Download

Documentation Dynamic Name Range
documentation, 13K, uploaded Aug 16, 2010 - 7 downloads

Release Notes

I see a lot of time people ask that they cannot find the last row of the data. One of the most complicated scenario would be, to assign the dynamic source range to a chart. Suppose I have a chart and the number of rows in my chart would keep on changing time to time, so how would I manage this? One option is to use VBA code and assign a new source data whenever it is refreshed. But do we really need code behind to resolve this problem? I would say no :)

Download the attached file, or visit http://excelnoob.blogspot.com/2010/08/dynamic-named-ranges.html for detailed information.

Thanks,
Vikas
http://excelnoob.blogspot.com