Advertisement
veronikaaa86

07. Full Address

Sep 7th, 2022
1,337
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub SubAddress()
  2.     Dim firstName, lastName, address, town, zipCode, country, fullAddress As String
  3.     firstName = Range("A5")
  4.     lastName = Range("B5")
  5.     address = Range("C5")
  6.     town = Range("D5")
  7.     zipCode = Range("E5")
  8.     country = Range("F5")
  9.     fullAddress = firstName & " " & lastName & ", " & address & ", " & town & ", " & zipCode & ", " & country
  10.    
  11.     Debug.Print fullAddress
  12.    
  13.     Range("G5") = fullAddress
  14. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement