Changing Row & Column Titles in a Excel.Worksheet using VB

[rlb_wpg]

Although I am able to put values in cells, I would
like to change the actual tab titles.
For instance, rather than the default cell/column title
of A, I would like to change this value to "Country Name".
And as for the cell/row title of 1, I would like to change
this value to "Canada". etc.
Does anyone know how I would do this using VB6 with an
Excel.Worksheet object (for Excel 2000).

THANKS!