Hello,
I am building my first VBA Macro Excel (button) and I need help with it as I am unfortunately unsuccessful. Basically in one column, I have name of the countries and I would like in the second column to have if it is a EU Country or Non-EU Country. I tried to test it only with one country (Germany) but I am still unsuccessful and it gives me the following error message
Dim customernationality As Integer, result As String
customernationality = Columns("AC").Value
If customernationality = Germany Then result = "EU Country"
Columns("AD").Value = result
I guess the code is wrong, if I may have some help with it
Thanks in advance
Benjamin
I am building my first VBA Macro Excel (button) and I need help with it as I am unfortunately unsuccessful. Basically in one column, I have name of the countries and I would like in the second column to have if it is a EU Country or Non-EU Country. I tried to test it only with one country (Germany) but I am still unsuccessful and it gives me the following error message
Dim customernationality As Integer, result As String
customernationality = Columns("AC").Value
If customernationality = Germany Then result = "EU Country"
Columns("AD").Value = result
I guess the code is wrong, if I may have some help with it
Thanks in advance
Benjamin