I use this code to copy and paste addresses into a excel sheet and it works well. However if there are blank lines between the name, address and city/state lines it fails. How can I modify it to remove the blank lines?
Sub SameAsBillTo()
Application.ScreenUpdating = False...