Thanks for help. I ll give the question answer thing a try,

As of now i do have a form, and it works great.
at first I had two different combo boxes and some check boxes that
controlled different configurations and options for layout, but now too
many people are using it for many different spreadsheets.
So I reconfigured the form so it now has three text boxes.
Example
Row Start = 2 ' the 2 is in the text box, and it tells the function
what row to start on
Group by Col = 5 ' this is the column that the info is grouped by
Value Col = 11 ' this is the column that they value is subtotaled for
each group

so what I would like is for the user to be able to enter
Row Start = 2
Group by Col = E 'use a letter instead of number
Value Col = K ' use a letter instead of number

i just figured that was the simplest way.
The other way would be to grab the names from the first row, which are
the column names, and create a drop down selection box.

This would be the preferable way, but I am not that experienced with
excel.

If I were using php I would take the values and create an array as I
ran through the columns of row 1,
Then I would create loop that put them into an html selection box with
the value being the column number, and the text would be the column
name.

Is this possible in excel? If so that would be the best way

Otherwise just being able to convert a letter to a number would be
fine.


--
trav
------------------------------------------------------------------------
trav's Profile: http://www.excelforum.com/member.php...o&userid=31420
View this thread: http://www.excelforum.com/showthread...hreadid=514461