Thank you so much charles. The code works great so far.
Just one question about the variables, c and firstaddress weren't declared so I declared them as variant. Is there a better data type that I should declare them for speed and memory.
thanks
Josh
Josh,
If the database is not large then declare as variant should be ok.
However I think
firstaddress c.Address should be Range
c as string
delete "Dim lrow As Long" you do not need it.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks