Dynamic Named Range Charts

Rating: No reviews yet
Downloads: 104
Released: Aug 16, 2010
Updated: Aug 16, 2010 by vikasbhandari2
Dev status: Stable Help Icon

Recommended Download

Application Dynamic Named Ranges
application, 13K, uploaded Aug 16, 2010 - 104 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 :)

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

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

Reviews for this release

No reviews yet for this release.