Find two strings in a range select cells in between and loop through range

**maxwell13** · 03-25-2018, 11:31 PM

Hi

I am using the below code to Find two strings in column A and select the cells between them.

I would like to loop through the entire range as the two strings appear more than once.

Please Login or Register  to view this content.

Thanks for any assistance

Jeff

**AlphaFrog** · 03-25-2018, 11:55 PM

Please Login or Register  to view this content.

**maxwell13** · 03-26-2018, 12:10 AM

Brilliant

Thank You AlphaFrog

**maxwell13** · 03-26-2018, 02:56 AM

Hi Again

This works perfectly however what would I need to edit if I want to use a partial match. I have tried changing xlWhole to xlPart but that doesn't want to work

Please Login or Register  to view this content.

**AlphaFrog** · 03-26-2018, 07:43 AM

Changing to xlPart is correct. Did you change all four?

Please Login or Register  to view this content.

**maxwell13** · 03-27-2018, 04:04 AM

Hi

Sorry for taking so long to get back to you and no I hadn't edited correctly.

All good now

Thanks for your help

Jeff

Find two strings in a range select cells in between and loop through range

LinkBack

Thread Tools

Rate This Thread

Display

Find two strings in a range select cells in between and loop through range

Re: Find two strings in a range select cells in between and loop through range

Re: Find two strings in a range select cells in between and loop through range

Re: Find two strings in a range select cells in between and loop through range

Re: Find two strings in a range select cells in between and loop through range

Re: Find two strings in a range select cells in between and loop through range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop thru all cells in range, find 1st match, move to next row - Help!

[SOLVED] Help with loop to select range of cells that meet criteria

[SOLVED] Need VBA to find letter A in Column A:A, select range, popup MsgBox then loop

Need to loop to a ceretain value then select a range of cells

For each cell in loop, find cells that contain the same in range and sum cor. matches

Loop to select range of cells representing a month....

[SOLVED] Loop through a range of cells to find unique entries

Bookmarks

Bookmarks

Posting Permissions