need help re hiding rows in a range based on cell contents

[jimredfield]

In Excel 2010 I have a single-column range (1x50) whose cells each contain zero up to a few short alphanumeric snippets separated by spaces (eg: etf, ad, etf 3m5, f hei7, etfg ...etc.). I need a VBA function which, when aimed at the range, hides (or un-hides) every row in which a specific snippet is found. If the snippet is "etf", both the cell with "etf" and the cell with "etf 3m5" above would be hidden, but the cell with "etfg" would not. If no snippet is provided, every row in the range is hidden.

The pseudo-code below lays out the logic I think, but I need help translating that into Excel 2010 VBA code. Assistance very much appreciated. - Jim

Please Login or Register  to view this content.

[AB33]

Jim,
A function returns a value in VBA, but it does not hide a cell (Action). What you need is a procedure-i.e a sub procedure. I think it would be easier to test a code if you could attach a sample excel book.

[jimredfield]

AB33 - Quite right re proc vs func - not thinking clearly here. Revised spec on attached worksheet. Thanks! - Jim

[AB33]

Jim,
why can not use a simple code? I am sure I am missing something

Please Login or Register  to view this content.

You can also use the istr function,but I am not sure If I follow your data

[jimredfield]

AB33 - I appreciate your help, but I think we lack common ground on what I'm trying to do. Let's see if someone else out there will chime in to sort me out. - Jim

[jimredfield]

AB33 - I appreciate your help, but I think we lack common ground on what I'm trying to do. Let's see if someone else out there will chime in to sort me out. - Jim

[watersev]

hi jimredfield, please check attachment, try to change value in C3 and D3 or one of them

[jimredfield]

Waterserv - Perfect solution, and with coding shortcuts/efficiencies well beyond my modest understanding of VBA. I also appreciate the error trapping. Thanks very much. (I remember seeing a drop-down that provided an opportunity to mark a thread 'solved' but I can't seem to find it. Aim me in the right direction and I'll do so for this thread, or feel free to do it at your end on my behalf.) - Jim

[watersev]

as per Forum Rules:

If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.