George Keen

Wow John, thanks for that informed response. It sure isn't easy is it? I'll see what I can do with that, and let you know how it turns out. Thanks again!

Greetings from Ohio! I'm new to this forum and to Macro Express, so I'm looking for some "beginners" tips here. Hope you all can help me. I'm trying to figure out how to paste a long list of home addresses into Excel, using Macro Express 3.6 They will be in the following format: "xxx Anystreet Rd, City" or "888 Spinning Rd, Dayton". (leaving off the state). I would also like to automatically pull the Estimated Home Values off of Eppraisal.com putting them into Excel to the right side of the address, into the next three columns, using some kind of a Macro. I sure would appreciate any help you might be able to offer. Thanks in advance. George