{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SVBA_Exercise"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SVBA_Exercise","index":0,"n_rows":200,"n_cols":12,"rows_kept":200,"cut":false,"hidden":false,"merged":[[14,9,19,15],[6,9,8,10],[6,11,8,15],[9,11,9,15],[12,11,12,15],[13,11,13,15],[10,11,10,15],[11,11,11,15],[9,9,13,10]]}
[]
["Country","Capital","Currency","Language"]
["Afghanistan","Kabul","Afghanistan","Pashtu and Dari"]
["South Africa","Cape Town, Pretoria and Bloemfontein","Rand","English"]
["Albania","Tirana","New lek","Albanian"]
["Germany","Berlin","Euro","German"]
["Andorra","Andorra La Vella","French franc","Catalan",null,null,null,null,null,"Instructions:",null,"Create a subroutine that will transfer the contents of a column into a line of another worksheet."]
["Angola","Luanda","Cuanza or Kwanza","Portuguese"]
["Antigua and Barbuda","Saint John's","East Caribbean Dollar","English"]
["Saudi Arabia","Riad","Saudi riyal","Arabic",null,null,null,null,null,"Reminder:",null,"ALT + F11 - Open VBE"]
["Algeria","Algiers","Algerian Dinar","Arabic",null,null,null,null,null,null,null,"Write the code in Exercise_Module"]
["Argentina","Buenos Aires","Argentinian peso","Spanish",null,null,null,null,null,null,null,"When ready press F5 to execute the code"]
["Armenia","Yerevan","Dram","Armenian",null,null,null,null,null,null,null,"Try not to write unneeded code"]
["Australia","Canberra","Australian Dollar","English",null,null,null,null,null,null,null,"When finished, press ALT + F8 to View Macros"]
["Austria","Vienna","Euro","German"]
["Azerbaijan","Baku","Azerbaijani Manat","Azerbaijan and Russian"]
["Bahamas","Nassau","Bahamian Dollar","English"]
["Bangladesh","Daca","Taka","Bengali"]
["Barbados","Bridgetown","Barbados Dollars","English"]
["Bahrain","Manama","Bahraini Dinar","Arabic"]
["Belgium","Brussels","Euro","French and Flemish"]
["Belize","Balmopan","Belize dollar","English"]
["Benin","Porto Novo","CFA franc","French"]
["Belarus (Belarus)","Polaminsk","Belarusian Ruble","Russian"]
["Bolivia","La Paz","Bolivian","Spanish"]
["Bosnia Herzegovina","Sarajevo","Landmark convertible","Servo-Croatian"]
["Botswana","Gaborone","Pula","English"]
["Brazil","Brasilia","Real","Portuguese"]
["Brunei","Bandar Seri","Brunei Dollar","Malay"]
["Bulgaria","Sofia","New lev","Bulgarian"]
["Burkina Faso","Ouagadougou","CFA franc","French"]
["Burundi","Bujumbura","Burundi Franc","French"]
["Bhutan","Timphu","Ngultrum","Dzongka and Nepalese"]
["Cape Verde","Beach City","Cape Verde Shield","Portuguese"]
["Cameroon","Iaundé","CFA franc","French and English"]
["Cambodia","Phnom Penh","New Riel","Khmer and Chinese"]
["Canada","Ottawa","Canadian dollar","English and French"]
["Qatar","Doha","Qatar Rial","Arabic"]
["Kazakhstan","Astana","Tenge","Kazakh"]
["Chad","Ndjamena","CFA franc","Arabic and French"]
["Chile","Santiago","Chilean Peso","Spanish"]
["China","Beijing","Iuan","Mandarin"]
["Cyprus","Nicosia","Cypriot pound and Turkish lira","Greek"]
["Singapore","Singapore","Singapore Dollars","English and Malay"]
["Colombia","Bogota","Colombian peso","Spanish"]
["Congo","Brazzaville","CFA franc","French"]
["Comoros","Moroni","Comorian Franco","Arabic and French"]
["North Korea","Pyongyang","North Korean Won","Korean"]
["South Korea","Seoul","South Korean Won","Korean"]
["Costa do Marfim","Abidjan","CFA franc","French"]
["Costa Rica","San jose","Costa Rican Colon","Spanish"]
["Croatia","Zagreb","Kuna","Servo-Croatian"]
["Cuba","Havana","Cuban Peso","Spanish"]
["Denmark","Copenhagen","Danish Crown","Danish"]
["Djibouti","Djibouti","Djibouti Franc","French and Arabic"]
["Dominica","Roseau","East Caribbean Dollar","English"]
["Egypt","Cairo","Egyptian pound","Arabic"]
["El Salvador","San Salvador","Salvadoran Colon","Spanish"]
["United Arab Emirates","Abu Dhabi","Dirrã","Arabic"]
["Ecuador","Quito","Dollar","Spanish"]
["Eritrea","Asmará","Nakfa","Arabic"]
["Scotland","Edinburgh","British Pound","English"]
["Slovakia","Bratislava","Slovak koruna","Slovak"]
["Slovenia","Ljubljana","Tolar","Slovenian"]
["Spain","Madrid","Euro","Spanish"]
["U.S","Washington","American dollar","English"]
["Estonia","Tallinn","Crown","Estonian"]
["Ethiopia","Addis Ababa","Birr","Aramaic"]
["Russian Federation","Moscow","Ruble","Russian"]
["Fiji","Suva","Fiji dollar","Fijian and English"]
["Philippines","Manila","Philippine Peso","Filipino"]
["Finland","Helsinki","Euro","Finnish, Swedish and Lapon"]
["Taiwan (Taiwan)","Taipei","New Taiwan Dollar","Mandarin"]
["France","Paris","Euro","French"]
["Gabon","Libreville","CFA franc","French"]
["Gambia","Banjul","Dalasi","English"]
["Ghana","Accra","New Cedi","English"]
["Georgia","Tbilisi","Lari","Georgian"]
["Great Britain","London","British Pound","English"]
["Grenade","Saint George's","East Caribbean Dollar","English"]
["Greece","Athens","Euro","Greek"]
["Greenland","Nuuk","Danish Crown","Danish"]
["Guatemala","Guatemala","Quetzal","Spanish"]
["Guiana","Georgetown","Guianese Dollar","English"]
["French Guiana","Cayenne","French franc","French"]
["Guinea","Conakry","CFA franc","French"]
["Guinea Bissau","Bissau","CFA franc","Portuguese"]
["Equatorial Guinea","Malabo","CFA franc","Spanish"]
["Haiti","Port Prince","Gourde","French"]
["Netherlands","Amsterdam","Euro","Dutch and Frisian"]
["Honduras","Tegucigalpa","Lempira","Spanish"]
["Hungary","Budapest","Florint","Hungarian"]
["Yemen","Sanaa","Yemeni rial","Arabic"]
["Marshall Islands","Majuro","American dollar","English"]
["Solomon Islands","Honiara","Solomon Islands Dollar","English"]
["India","New Delhi","Indian Rupee","Hindu and English"]
["Indonesia","Jakarta","Rupee","Indonesian"]
["Will","Tehran","Iranian rial","Persian and Turkish"]
["Iraq","Baghdad","Iraqi Dinar","Arabic and Kurdish"]
["Ireland","Dublin","Euro","English and Irish"]
["northern Ireland","Belfast","British Pound","English and Irish"]
["Iceland","Reykjavik","New Icelandic krona","Icelandic"]
["Israel","Tel Aviv / Jerusalem","New Shekel","Hebrew"]
["Italy","Pomegranate","Euro","Italian"]
["Jamaica","Kingston","Jamaican dollar","English"]
["Japan","Tokyo","Yen","Japanese"]
["Jordan","Love","Jordanian Dinar","Arabic"]
["Kiribati","Bairiki","Australian Dollar","Ikiribati"]
["Kuwait","Kuwait City","Kuweitian dinar","Arabic"]
["Laos","Vientiane","Kip New","Lao and French"]
["Lesotho","Maseru","Loti","English"]
["Latvia","Riga","Lats","Latvian"]
["Lebanon","Beirut","Lebanese Pound","Arabic"]
["Liberia","Monrovia","Liberian Dollar","English"]
["Libya","Tripoli","Libyan Dinar","Arabic"]
["Liechtenstein","Vaduz","Swiss franc","German"]
["Lithuania","Vilnius","Litas","Lithuanian"]
["Luxembourg","Luxembourg","Euro","Luxembourgish"]
["Macedonia","Skopje","New Macedonian dinar","Macedonian"]
["Madagascar","Antananarivo","Malagasy Franco","French and Malagasy"]
["Malaysia","Kuala Lumpur","Malaysian Ringgit","Malay"]
["Malawi","Lilongan","Malawian Cuacha","English"]
["Maldives","Male","Malaysian rupee","Maldivian"]
["Mali","Bamako","CFA franc","French"]
["Malta","La Valletta","Maltese Lyra","Maltese and English"]
["Morocco","Rabat","Moroccan Dirham","Arabic"]
["Mauritius","Port Louis","Mauritian Rupee","English"]
["Mauritania","Nuakchott","Uguia","Arabic"]
["Mexico","Mexico City","Mexican new peso","Spanish"]
["Myanmar","Yangum","Kiat","Burmese"]
["Micronesia","Palikir","American dollar","English"]
["Mozambique","Maputo","Metical","Portuguese"]
["Moldavia","Chisinau","Read","Romanian"]
["Monaco","Monaco-Ville","French franc","French"]
["Mongolia","Ulan Bator","Tugrik","Mongolian"]
["Namibia","Windhoek","Namibian Dollar","English"]
["Nauru","Yaren","Australian Dollar","Nauru"]
["Nepal","Kathmandu","Nepalese Rupee","Nepali"]
["Nicaragua","Managua","Cordoba gold","Spanish"]
["Niger","Niamei","CFA franc","French"]
["Nigeria","Abuja","Naira","English"]
["Norway","Oslo","Norwegian krone","Norwegian"]
["New Zealand","Wellington","New Zealand Dollar","English"]
["Oman","Peddler","Rial omani","Arabic"]
["Panama","Panama City","Balboa","Spanish"]
["Palau","Koror","American dollar","English and Palauense"]
["Papua New Guinea","Port Moresby","Kina","English"]
["Pakistan","Islamabad","Pakistani Rupee","Pumjabi"]
["Paraguay","Asuncion","Guarani","Spanish"]
["Peru","lime","New sun","Spanish"]
["Poland","Warsaw","Zloty","Polish"]
["Puerto Rico","San juan","American dollar","English and Spanish"]
["Portugal","Lisbon","Euro","Portuguese"]
["Kenya","Nairobi","Kenyan Shilling","Quisvaili"]
["Kyrgyzstan","Bishkek","Sound","Kyrgyz"]
["UK","London","British Pound","English"]
["Central African Rep.","Bangui","CFA franc","French"]
["Dominican Rep.","Santo Domingo","Dominican peso","Spanish"]
["Czech republic","Prague","Czech koruna","Czech"]
["Romania","Bucharest","Romanian leu","Romanian"]
["Rwanda","Kigali","Rwandan Franc","French"]
["Samoa","The washbasin","Splint","English"]
["San marino","San marino","Euro","Italian"]
["Saint Lucia","Castries","East Caribbean Dollar","English"]
["Saint Kitts and Nevis","Basseterre","East Caribbean Dollar","English"]
["Sao Tome and Principe","Saint Thomas","Fold","Portuguese"]
["Saint Vincent and the Grenadines","Kingstown","East Caribbean Dollar","English"]
["Seychelles","victory","Seychelles Rupee","English, French and Creole"]
["Senegal","Dakar","CFA franc","French"]
["Sierra Leone","Freetown","Leone","English"]
["Serbia and Montenegro","Belgrade","Dinar (Serbia) and Euro","Serbian and local dialects"]
["Syria","Damascus","Syrian pound","Arabic"]
["Somalia","Mogadishu","Somali Shilling","Somali"]
["Sri Lanka","Colombo","Sinhala rupee","English"]
["Swaziland","Mbabane","Lilangueni","English"]
["Sudan","Khartoum","Sudanese Dinar","Arabic"]
["Sweden","Stockholm","Swedish krona","Swedish"]
["Switzerland","Bern","Swiss Franc","German and French"]
["Suriname","Paramaribo","Surinamese guilder","Dutch"]
["Tajikistan","Dushanbe","Rubik Tajik","Tajik"]
["Thailand","Bangkok","Baht","Thai"]
["Tanzania","Dodoma","Tanzanian Shilling","English"]
["Togo","Lomé","CFA franc","French"]
["Tonga","Nukualofa","Daddy","English"]
["Trinidad and Tobago","Port of Spain","Trinidad and Tobago Dollar","English"]
["Tunisia","Tunis","Tunisian Dinar","Arabic"]
["Turkmenistan","Ashkhabad","Turkmen Manat","Turkmen"]
["Turkey","Ankara","Turkish lira","Turkish"]
["Tuvalu","Fongafale","Australian Dollar / Tuvaluan","English"]
["Ukraine","Kiev","Hryvna","Ukrainian"]
["Uganda","Kampala","New Uganda Shilling","English"]
["Uruguay","Montevideo","Uruguayan Peso","Spanish"]
["Uzbekistan","Tashkent","Sum","Uzbekistan"]
["Vanuatu","Porto Vila","Vatu","French and English"]
["Vatican","Vatican CITY","Italian lira","Italian and Latin"]
["Venezuela","Caracas","Bolívar","Spanish"]
["Vietnam","Hanoi","New dongue","Vietnamese"]
["Zaire","Kinshasa","New zaire","French"]
["Zambia","Lusaka","Zambia cuacha","English"]
["Zimbabwe","Harare","Zimbabwe Dollar","English"]