Thread: averaging macro

hello
my table is same this. i have 120 countries and approximately 200 common variables in different sheet. this table is sheet1 about GDP of some countries. i want a macro that when i choose a country,
fill the "average" row with the average value of the others.
thanks a lot

Country Name 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005
Austria 240 236 209 214 213 194 193 208 256 294 306
Belgium 284 275 249 255 254 232 232 252 310 358 371
Bosnia and Herzegovina 2 3 4 4 5 5 5 6 8 9 10
Cyprus 9 9 9 9 10 9 9 10 13 15 NA
Denmark 182 184 170 174 174 160 160 174 214 245 259
France 1570 1574 1426 1473 1456 1328 1340 1457 1800 2060 2127
Germany 2523 2438 2161 2184 2144 1900 1891 2019 2442 2751 2795
Ireland 67 74 81 88 97 96 105 123 157 184 202
Italy 1126 1260 1192 1217 1201 1097 1117 1219 1507 1724 1763
Luxembourg 21 21 19 19 21 20 20 23 29 34 36
Netherlands 433 429 393 410 416 387 401 438 538 607 624
Romania 35 35 35 42 36 37 40 46 60 75 99
Slovenia 20 20 20 21 22 19 20 22 28 33 34
Spain 597 622 573 601 618 581 608 686 881 1040 1125
Sweden 251 273 249 250 254 242 222 244 304 350 358
Switzerland 315 303 262 269 265 246 250 276 323 359 367
Turkey 169 181 189 200 184 199 145 184 240 303 363
United Kingdom 1134 1191 1327 1425 1465 1443 1435 1571 1806 2132 2199
Average