I have a great macro/WS that DMille wrote for me that provides for a Dynamic Time Horizon. The attached model has the ability to add new "Use Cases" and when it does, the Time Horizon capability does not work correctly. When the rows are replicated (i.e. click the + User Case button), and then you change the Time Horizons, the new User Cases do not respond accordingly. The original one does but not the new ones. I think it is because it is "hard coded" into the macro. I think it's in these two reference points:
Set rngClear = Range("AJ2", Cells(4, Columns.Count)).Resize(6)
numPeriods = Range("AB3")
Thank you in advance.....