Is there any way to search a range within a range?

[Halen]

Hello

Okay, I need help! Is there any way to search a range within a range?

For example, I have a load of data in my worksheet. When I run my macro it takes the best part of 10 minutes beacuse it is so big. So, in trying to cut the time down I plan to limit the range that VB searches when doing For each...Next and If...Then's etc.

So I've got my overall range which includes all my data, but I now want to be able to search just column B, within the overall range.


Any hints/tips/methods/help?

Cheers,
H

[jindon]

Can't you just try Find method?

It is the fastest in finding

[Halen]

Nope, can't use the find option because I am going through the column and any cells that have bold font I am deleting the entire row

[jindon]

For Each Cell In Range("b:b")

...

....

Next

is this waht you want?

[Halen]

No, what I wanted was to select all of the data in column B that was within my range.

I appreciate the help but I've sinse found out a method that works for me :o)

range(range("A""), Range("N" & Range("A2").CurrentRegion.Rows.count)).select

Thanks anyway