I have created a retirement calculator that is very complex in nature (the theory). In the end, I have formulas that create 35 years of annual result data (35 columns).
I use do until to seed a cell which increases the period I am looking at by one month. It then gives me the 35 years of results in one row. I then need to copy the (values) results down and then provide a new seed. It is all working, but it can take 3-5 minutes to run. I suspect there is a better way of getting the ending data without copy/paste values down to the target and then using xldown in the formula:
Selection.Copy
Selection.End(xlDown).Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
(then loop again)
Please help! Thank you in advance.
I use do until to seed a cell which increases the period I am looking at by one month. It then gives me the 35 years of results in one row. I then need to copy the (values) results down and then provide a new seed. It is all working, but it can take 3-5 minutes to run. I suspect there is a better way of getting the ending data without copy/paste values down to the target and then using xldown in the formula:
Selection.Copy
Selection.End(xlDown).Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
(then loop again)
Please help! Thank you in advance.