Hi gmaxey, thanks for the tips on submitting and the speedy replies. I've tried the code you provided with a single scientific name, and it works exactly as expected. Thanks! However, in my lack of VBA knowledge, I'm struggling to incorporate it into the excel array that I call earlier in the code. I'm not quite sure what you mean by 'use your Excel file "Find" phrase as the replacement text'. Could you please elaborate a bit on this? Thanks!
|