Choose your language

If Then Insert Cell

Intermediate Exercise


Statement

Make a loop in the worksheet (that contains country data) to identify the lines between which the first letter of the country name changes (e.g. from A of Azerbaijan to B of Bahamas) Whenever there is a change insert in between a blank cell with green background and white borders


Suggested Concepts:

Remember that in most cases there is more than one way to solve the exercise.

Hint: Use the If statement to compare the first letter of the names between each line


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape