Hello, looking for some assistance with a macro. I am trying to figure out how to search a column to locate the 1st cell that does NOT match a specific value. I would like to avoid looping thru rows as the spreadsheet can be rather large (100's of columns x 1000's of rows).
For example:
Column A contains only 2 possible values: "P" and something else, say "String A" but this will vary. So need to search/find <> "P" to extract "String A" for copying to another sheet.
Column B contains only 2 possible values: "P" and something else, say "String B" but this will vary. So need to search/find <> "P" to extract "String B" for copying to another sheet.
...and so on.
Thanks for any help and suggestions.
Ron
For example:
Column A contains only 2 possible values: "P" and something else, say "String A" but this will vary. So need to search/find <> "P" to extract "String A" for copying to another sheet.
Column B contains only 2 possible values: "P" and something else, say "String B" but this will vary. So need to search/find <> "P" to extract "String B" for copying to another sheet.
...and so on.
Thanks for any help and suggestions.
Ron