Hi! I have a problem with a loop. I want to search the entire spreadsheet for a cell that contains the text ?Sec type?? However there are two rows that I do not want to search. These to rows are: segment.row and secID.row. These two rows each contains a cell with the text ?Sec type?? Thus, I want to search for any additional cells with that text. If an additional cell containing the text ?Sec type??is found I want to store the address of that cell in the variable c. If no additional cell is found I want to set c = Nothing or something that indicates that no additional cells were found.

Hi

A quick fix would be to dim a new variable d and set it equal to c if your test (c.Address <> firstAddress And (c.row = segment.row Or c.row = secID.row)) is true. Then use d in your code.

Hello Anders,

You may have solved this already but if not I think you need a way to differenciate the rows that you want to exclude from the search. If your sheet is static and values remain in their respective rows then you can use the row number to check if the results should be recorded. Or even if the value is bold or at least something that you can check in you loop that's says this shouldn't be included carry on.