Insert blank rows in table range

Closed
Surya4vba
Posts
2
Registration date
Monday September 17, 2018
Status
Member
Last seen
September 19, 2018
- Sep 18, 2018 at 03:43 AM
 Blocked Profile - Sep 19, 2018 at 03:57 PM
Am trying to create a macro for below data, the series of data will be in below format.
Bahrain
United Arab Emirates
Oman
Qatar
Dammam - KSA
Riyadh - KSA
Jeddah - KSA
Kuwait
Egypt
Lebanon

If above data order is not present in the table of excel sheet, need to insert a blank row in between.

Bahrain

Oman

Qatar


Jeddah - KSA
Kuwait
Egypt


Thanks in advance for help.
Surya

1 reply

Blocked Profile
Sep 18, 2018 at 04:51 PM
So if it isn't on the table, how are we to compare it? How is the macro to know that it isn't in the list? It doens't exist! See the flaws?
0
Surya4vba
Posts
2
Registration date
Monday September 17, 2018
Status
Member
Last seen
September 19, 2018

Sep 19, 2018 at 02:32 AM
you are right, i missed that point.. thanks for bringing it up. please help me with a macro.. have no knowledge in macros
0
Blocked Profile
Sep 19, 2018 at 03:57 PM
YOu record macros. Record what you want it to do, and look at the code. Change what can be changed to a variable! If you are trying to write code, then write something and post back, and we will help.
0