+ Reply to Thread
Results 1 to 1 of 1

sorting changes the value of range-variable

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2016
    Posts
    187

    sorting changes the value of range-variable

    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

    Please Login or Register  to view this content.
    Does anybody know the explanation of this behavior?

    Thanks
    Last edited by HarryKlein; 03-05-2012 at 06:58 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1