Actually it just searches until the first value is found, but would only
search in the specified range.

Rowan has shown additional code to ensure there is data below row 4.

--
Regards,
Tom Ogilvy


"serdar" wrote in message
...
thats ok.when i use this range as:

rng.Find(x, LookIn:=xlValues)

all 65536 cell are searched? or just searches until the last
used/formatted?


"Rowan Drummond" , haber iletisinde sunlari
...
One way:

Dim c As Range
Set rng = Range(Cells(5, 1), Cells(Rows.Count, 1))
MsgBox rng.Address

Hope this helps
Rowan

serdar wrote:
say i wanna set a range of an entire column "minus" first 4 rows. How
to
do this in VBA?