sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
I have a spreadsheet that grabs lead information from a site I have an account with. It's designed to go to a project page on the site, grab a group of information from the page, then manipulate the data I want into the form I want. All is good but for 2 problems that sometimes come up- easy to work around for me, but I'm trying to dummy the spread down for a salesman to use and therefore want to limit the 'what to do if this happens' list
The primary question I want to deal with is....occasionally, one of the items I am looking for is not there. When that happens now, my macro stops and I type the item in just so I can resume the macro. I would like to automate that.
I am utilizing a find_range function I found online to find items like project name, address, county, etc....project contact is the item that occasionally does not exist. I would like to somehow have the macro ignore and continue if the function does not find the words 'project contact'
Find_Range("Project Contacts", Range("A:A")).Select is the line that first deals with the item- the find_range function looks in column A for the words project contacts. It is part of a loop and I'd like the loop to finish so it can go on to the next record.
I'm thinking if I find the resolution for this, I can extrapolate a resolution to my other problem.
The primary question I want to deal with is....occasionally, one of the items I am looking for is not there. When that happens now, my macro stops and I type the item in just so I can resume the macro. I would like to automate that.
I am utilizing a find_range function I found online to find items like project name, address, county, etc....project contact is the item that occasionally does not exist. I would like to somehow have the macro ignore and continue if the function does not find the words 'project contact'
Find_Range("Project Contacts", Range("A:A")).Select is the line that first deals with the item- the find_range function looks in column A for the words project contacts. It is part of a loop and I'd like the loop to finish so it can go on to the next record.
I'm thinking if I find the resolution for this, I can extrapolate a resolution to my other problem.