Fill in missing info in the worksheet

[mayankgo]

How do I select cells which are blank in a worksheet? and thn move to next worksheet to do the same?

I'm doing this exercise
https://www.wiseowl.co.uk/training/exercises/ex-1737.htm

No idea how to do it.

 

[oldbrewer]

you need to find each blank cell, then look up the country on a list of countries and their capitals. You will find that on the web, copy it and paste it in excel, sort the countries into alphabetical order, name the table "capitals" and if country with a blank next to it is in D1, in E1 put =vlookup(D1,capitals,2)

 

[mayankgo]

you need to find each blank cell, then look up the country on a list of countries and their capitals. You will find that on the web, copy it and paste it in excel, sort the countries into alphabetical order, name the table "capitals" and if country with a blank next to it is in D1, in E1 put =vlookup(D1,capitals,2)

But I need to write a macro not use vlookup.

 

[oldbrewer]

using a macro, run down the column till you find a blank. Move one cell to the left and set say CC= to that cell.

Then run down the list of countries till you find a match and set say CAP one cell to the right. Now run down the first column till you find the blank and set that cell to CAP. Now repeat the whole process.