Hi guys,
I will make my issue as quick and concise as possible. I have the following code:
As you can see I have currently set the range to Q500. I would need the autofill destination to be dynamic, depending on what is entered in the cell marked "Tenure" in Excel. For example if the tenure cell value is 10, I want the range to be: Range("A17:Q[Tenure*12+15]), so Range("A17:Q135"). To help, I had the previous copy paste code that worked but was too slow:
How do I specify that range with autofill? Any assistance appreciated,
thank you,
Jurij
Bookmarks