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!

[Nitro]

According to my knowledge, I don't think you can change "A" to another name. I am almost sure, unless you know how to. If you know how to, show me the steps and I will try to post some code against your steps.

Most spreadsheets have column titles in the second or so row. Thats pretty standard stuff. I think your users would get confused if you could change "A" etc.

[rlb_wpg]

I found it was done using pivot tables in Excel
(something I know nothing about).

Warning....warning....warning

The Column Headers plus row ids should not be changed!!!!

They are used throughout macro and calculations.

Any spreadsheet package from VisiCalc to Lotus123 to Excel uses the same layout with cells id by Column:Row

ie cell(A3). Your users will be confused if you change these constants, which l still don't think you can