Hi Catalin! Thank you so much for your response.
Few stupid questions flying your way now. I'm decent with VBA in Word but for some reason I'm dead in the water with Excel.
What is the name of your script? For instance, someone in another forum gave me a script. The first line was 'function extractemail' so whenever I want to run the script I click on the cell to the right of the cell with the email in it and I type =extractemail. What do I type for yours? If it's ValidareAdresaEmail, I tried it and ended up with the word TRUE in the cell, nothing else.
My second question is one I haven't yet had answered in the other forum and I'm sure it's because they're too busy shaking their heads at how clueless I am. How do I get these scripts to run on multiple rows? For instance with the other script I was highlighting all cells in the column next to the cells I wanted emails extracted from (in this case, cells B1 to B22), then in the formula field entering =extractemail(A1:A22). But I would always end up with #VALUE!
Thanks again for all your assistance.
|