Array being resized when passing a Range from worksheet 

Array being resized when passing a Range from worksheet
I hope you found a solution that worked for you :)
The Content is licensed under (meta.stackexchange.com/help/l...) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!
(stackoverflow.com/users/5336948/forward-ed)Forward Ed
(stackoverflow.com/users/11683/gserg)GSerg
(stackoverflow.com/users/9814069/vbasic2008)VBasic2008
(stackoverflow.com/users/20643658/black-cat)Black cat
(stackoverflow.com/users/23186764/mgonet)MGonet
A special thanks goes out to the (stackoverflow.com/questions/78052083/array-being-resized-when-passing-a-range-from-worksheet)Stackexchange community
I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de
vba arrays excel