This is cross posted here:
https://www.mrexcel.com/forum/excel-...ange-data.html

I answered this on the mrexcel site, so i am not happy: please read about cross posting:

https://www.excelguru.ca/content.php?184