Hello,
I found something strange
I made a code, in which I set a range-var by using the find function.
On a different sheet I want do do things with the rows, where the value of the given column is the same (what I found on the previous sheet. )
I use the do while loop statement, therefore I sort the range based on the column where I expect the occurence of he searched value.
But sometimes I experience, that the value of range variable changes when the sorting is done.
I do it like this
Does anybody know the explanation of this behavior?
Thanks
Bookmarks