Constantly Changing Range

[NegativeKurtosis]

Hello all Excel Users,

Wondering how I might go about achieving the following :

I have a link from Matlab 9.5.0.944444 (R2018b) to Excel 2016 and below is a code snippet and explanation of what I am trying to achieve -

1. MLEvalString "AD = wdenoise(AC,5, 'Wavelet', 'db9','DenoisingMethod', 'UniversalThreshold',
2. 'ThresholdRule', 'Soft', 'NoiseEstimate', 'LevelIndependent');"
3. MLGetMatrix "AD", "AD5"
4. MatlabRequest
5. Range("AD4100").Copy Range("AE4101")
6. Range("AE5").Delete Shift:=xlUp
7. Range("AE4101").Copy Range("AF4101")
8. Range("AE5").Delete Shift:=xlUp
9. Range("AF5").Delete Shift:=xlUp
10. MLGetMatrix "AF", "AF5"
11. MatlabRequest


Code snippet line notes :
1 & 2 - Wavelet parameters getting assigned in Matlab to Excel column AD
3 - Wavelet parameters getting listed beginning in column AD 5
4 - Matlab making the request from # 3 to Excel
5 - 9 These lines should be pretty familiar to most Excel users....basic copy / paste stuff with a couple delete shift up commands.
10 - Wavelet parameters getting listed beginning in column AF 5
11 - Matlab making the request from # 10 to Excel

The problem I am trying to solve is to update range AF5 : AF4100 but ONLY the LAST value. How can I bring in current values to it, to begin the analysis, THEN, only update AF4100 every time a new values comes into Matlab and then delete / shift up those values so that I always maintain the same number of values in my
range which is 4096. I am having no issues what so ever communicating with Matlab, just trying to figure out how to begin and update this ever changing range in Excel. Any examples, links, suggestions etc would be
greatly appreciated.

Thanks,
Richard