If you only have two values and they are grouped together/sorted, how could
the area be 1200 to 3500

in any event, if that is the case, the you could use Find to find the first
Value1 as well.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
set rng = Columns(4).Find("VALUE2")
if not rng is nothing then
range(cells(1,1), rng.offset(-1,0)).EntireRow.Select

Look in help in VBA for the find method to see other arguments that might
affect your results.

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
My column "D" has only two values in it, (VALUE1 and VALUE2). My sheet
is
sorted by this column. What I want need my macro to do is only select
the
rows that have VALUE1 in column "D". Each time I run this the file size
would be different, so the first time my selection might be rows 1
through
1855. The next time it might be rows 1200 through 3500. The selection
will
always be grouped together because of the sort.


T.I.A.
Ed