Hide row based on cell value

[kamaflage]

Hi Experts,

Can someone please improve the code below.
What it does is search a column for "Yes" and then hide that row.

The below code works perfectly however now that i am doing over 2000 rows that needs to be hidden it runs very slow.
Is there a way to speed it up?

Please Login or Register  to view this content.

[PCI]

"Is there a way to speed it up?" yes certainly
Which column is it used to search for "Yes" ?
The best would be to have a sample Excel file

[PCI]

Try

Please Login or Register  to view this content.

[kamaflage]

Hi PCI,
Your code works perfectly,
Can you please explain more about " set hiderg = union (hiderg, f)"

This is something new to me and I would like to understand so that I can use it in other codes.

[PCI]

Please Login or Register  to view this content.

It requests the range HideRg to be "merged" with range F into HideRg
Final HideRg is the union of Original HideRg and F

[berlan]

As the HideRg could also be empty, change the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[PCI]

Thank you berlan, that's true it could happen there is no "Yes"

[kamaflage]

Thank you,
So this means I could use this same code with a slight modification to copy the found rows to a new worksheet or move a offset value?

[kamaflage]

I have been testing out the VBA code and I am impressed with the speed and flexibility of options.

Please Login or Register  to view this content.

Now i am just being greedy here but how would you apply wildcards to

Please Login or Register  to view this content.

and also what happens if I have multiple values that i want the same action taken on? example

Please Login or Register  to view this content.

,

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[PCI]

Some comments:
next code seems curious, is used HideRg in HideRg

Please Login or Register  to view this content.

Some questions
about wildcards is it to use with "Yes" and "no" and "maybe"

[kamaflage]

I would like to add a wild card search so that it will pick up "yesterday" " yes" or "yesteryear".

The yes no and maybe is for when I want to search for multiple strings.

[PCI]

"with a slight modification to copy the found rows to a new worksheet or move a offset value? "
Yes, here a suggestion: NOT TESTED

Please Login or Register  to view this content.

[PCI]

Here we are
Concerning the second macro (Yes + wildcards ) no matter if it is upper or lower case

Please Login or Register  to view this content.

[kamaflage]

Hi PCI,

Your code works flawlessly.

Can I get further explanation of

Please Login or Register  to view this content.

?

[PCI]

Please Login or Register  to view this content.

We have to check if F.value contains the string WdStg = "Yes"
We change the 2 strings in uppercase using UCase
We replace WdStg by nothing in F if it exist, therefore the length of F.value (Len(Replace(UCase(F.Value), UCase(WdStg), "")) should be reduced and different to the original length (Len(F.Value) )

[kamaflage]

Hi PCI,

Thank you for the explanation.
You should be a teacher, i now understand

[PCI]

Thank you.
The reward is your thanks and my satisfaction when you have understood.