I have a sheet with values similar to this:
148 407 118
118 10003 169 364 15
15 222 67
67 296 69
69 298 24
24 291 177


148 407 118
118 10003 169 10004 20 223 13
13 213 121
121 370 124
124 374 145


186 452 12
12 212 50
50 268 47
47 10018 74 10084 58
58 285 141
141 399 143

I wish to select each region or set of values i.e there are three in
the example given above before cuting the values and copying to a new
sheet. I need a macro that can loop through the sheet, find a value
(i.e. anything that isn't blank) within a cell to identify a new
region, select that region, cut to a new sheet, return to the original
sheet before continuing with again.
Thanks