Sorry, I obviously didn't make myself very clear. What I want to do is select multiple rows that are not next to each other, the equivalent of:
Range("9:9,12:12,14:14,19:19,23:23").Select
...where only rows with 0 in column G are selected. With sheets you can use
sheets.("MySheet").select(False)
to add to collection of selected sheets, but this doesn't work with range.select.
Is there anyway you can do this?