Hello,

I am working on a macro that loops through a range of cells "A2:A12", takes those cells' values, and tacks them on to a URL that I need to get a website for different IDs. Ex. If A2 was "123" the macro would go to "google.com/123".

I was importing a table with relevant info, but the table reference # changes on each itteration. I found an alternative solution: if the website contains the words "ceased" "no longer" or "historical", an output of "inactive" would suffice.

Long story short: if a website contains those words a flag of "Inactive" goes in the cell next to the looping cell.

Here's the code I started with:

<Code> 
Please Login or Register  to view this content.
</Code>

Thanks!