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

Insert blank rows in table range
Insert check mark in word - Guide
Insert key - Guide
How to delete part of a table in word - Guide
How to insert photo in word for resume - Guide
Back alley table - Download - Adult games

1 response

Answer 1 / 1

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?

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

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.

Similar discussions

encryption message several time in chat

How can I make my name text invisible in Discord

How to add Rows automatically based on Cell Value In Excel?

Similar discussions

Subscribe To Our Newsletter!