Re: select a row based on the text value of a cell
you can use "Union" to select multiple rows. here is some code that i used arbitrary values to select the row i want, then add that selection to a range.
Range("16:16").Select Set temprange = Selection Range("20:20").Select Set multirange = Union(temprange, Selection) multirange.Select Set temprange = Selection Range("26:26").Select Set multirange = Union(temprange, Selection) multirange.Select
the trick will then be to swap my arbitrary values with meaningful ones. i would use an array... go down each row and if a cell in that row contains the data you want, load the array with that row number. increment the array and do it again for the next row. then when you've fully loaded up your array, plug the array into the range object, then add the range to your multirange. make sense? i might be able to help with that if needed =)