Hi.

I'm trying to redesign a database, originally done in Access 2003, so
exported tables to Excel to analyse existing records, and in this instance,
maximum LEN in each column that's text.
I want to program a macro which:
1. asks, via InputBox, which column to analyse;
2. starting from the row after the header, counts LEN for the record and
moves on to the next row; and
3. returns, via MsgBox, MAX value amongst all LEN counted.

I've been trying to teach myself Excel VBA programming by following John
Walkenbach's "Excel 2007 Power Programming with VBA" but I'm obviously not
"getting it" and can't even program to do COUNTA, starting with InputBox and
ending with the value shown with MsgBox.

Please help!
--
Maki @ Canberra.AU