Dynamic Named Range Chart

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

Recommended Download

Source Code Dynamic Named Range
source code, 13K, uploaded Aug 16, 2010 - 14 downloads

Release Notes

Hi All,

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 :)

Please download the attached file, or visit http://excelnoob.blogspot.com/2010/08/dynamic-named-ranges.html for more information!

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