Hi Dave,

sorry I should have explained ..

my macro uses the contents of cells on sheet1 as a pointer to the cells on
sheet2 ..

Example:

(sheet1, values in columnA, first four rows)
A1
AA3
AC2
B1

The macro uses the value (i.e. A1, AA3, etc) as a pointer to the destination
cell for sheet2.

Therefore simply hiding the row and colum header doesn't solve the problem,

Kevin



"Dave Peterson" wrote:

You could use column A and row 1 as your headers and make them anything you
want.

You could even hide excel's row and column headers:
tools|option|view tab|uncheck row & column headers

kevinm wrote:

I have a macro which fills cells on sheet2 with colors based on cells from
sheet 1. Sheet 2 is supposed to represent the physical pinout of a computer
chip I am designing.

The pinout diagrams published by the manufacturer show the top view of the
chip, the rows, from top to bottom are labled A - AP, the columns are labled
1 - 34. This is the reverse of how rows and columns are displayed in Excel.

I would like to change the labeling of the rows and columns in Excel to
match the pinout diagram printed in manufacturers datasheet, is this possible?

See page 279 of the following PDF file for an example of the pinout diagram
I am trying to represent in my spreadsheet:

http://direct.xilinx.com/bvdocs/userguides/ug075.pdf

thanks,

Kevin

--

Dave Peterson