How to search a range for a suburb in a large range

How to search a range for asuburb that if found could contain up to 50
different corresponding post codes. After its found how can it be checked
againsts an example.

Can you provide more details? What does your data look like (what is in
rows, cols)?

"Bogan.." <Bogan..@discussions.microsoft.com> wrote in message
news:B16694E7-7C5E-41E2-AA5B-637504697E73@microsoft.com...
> How to search a range for asuburb that if found could contain up to 50
> different corresponding post codes. After its found how can it be checked
> againsts an example.

set rng = Range("A1:A50").Find( "string")

set rng1 = rng.offset(0,1).Resize(1,50)

for each cell in rng1
if cell.Value = "ExampleValue" then
msgbox "Found"
end if
Next

--
Regards,
Tom Ogilvy





"Bogan.." <Bogan..@discussions.microsoft.com> wrote in message
news:B16694E7-7C5E-41E2-AA5B-637504697E73@microsoft.com...
> How to search a range for asuburb that if found could contain up to 50
> different corresponding post codes. After its found how can it be checked
> againsts an example.