Incrementing letters, ignoring blanks

[MykolW]

Good day to all,

I have a spreadsheet that I'm designing a quote template in. I want the different items of the quote to have a ltter beside it that auto increments, even if a line is skipped. Right now the formula that I'm using is =IF(D59>0,CHAR(CODE(A58)+1),""), but that only works if every cell above it is filled out.

I was also wondering if there is vba that will check the contents of a cell and resize the row height to fit everything. I've designed the template with very small columns and then used merging of cells to get around needing different widths on different pages. The issue I'm having is that the auto resize doesn't work with merged cells, so I'm thinking I'm going to need vba to do the resizing.

Cheers,

Michael

 

[MykolW]

I forgot to add that I'm on Windows XP and using Office 2007.

As to the incrementing formula, an office mate suggested that MAXA or MAX might be the best way to get to my goal. I have tried the following formula, but it gives and error. I'm not sure why.

=IF(D60>0,MAXA(CHAR(CODE(A56:C59)+1),""))

Note: The reason I used A56:C59 is because that column of cells has been merged (A56:C56 is now one cell).

If anyone has any ideas about the resizing of the cells with VBA, that would still be appreciated too.

 

[MykolW]

bump