Toppers;

Thanks for getting back again! I entered the code you sent me
and now I get a different error message. The Code I have for a test is shown
below.

Dim ColumnNo As Long
Dim ReqColumn As Range

Set ReqColumn = Application.InputBox("Give Me the Column", Type:=8)
Right After I enter the Column (HJ) and Depress the Enter Key, I get the
message Below and Hit The Enter Key!

ColumnNo = ReqColumn.
Column MsgBox ColumnNo

The reference you typed is not valid or you did not provide reference where
one was required!

Len


"Toppers" wrote:

in VBA ( I don't "speak" C):

Sub x()
Dim ReqColumn As Range
Dim ColumnNo As Long

Set ReqColumn = Application.InputBox("Give Me the Column", Type:=8)
ColumnNo = ReqColumn.Column
MsgBox ColumnNo

End Sub
"Len" wrote:

Toppers;

Thanks for Responding.

I tried this little code, I got the error Message:

Sub or Function not defined.

Dim ReqColumn as String
Dim ColumnNo as Long

ReqColumn = Input("Give Me the Column")
ColumnNo = Column(ReqColumn) Error
ColumnNo = DD1 Error
ColumnNo = Column(DD) Error
ColumnNo = Column(DD,1) Error

I get the same error message on all five?

Also there is a "C" programmer that changed Excel in 1998 to expand to 384
columns. I do not know him, but I have seen the spreadsheet so I know it
worked. I know he made a lot of changes that I am not going to attempt!

Thanks Again

Len

"Toppers" wrote:

You will need Excel 2007 for more than 256 columns (the limit until this
release)

=Column(HP1) will return column number

HTH

"Len" wrote:

The testing department wants me to assist them in a large project that should
be written in "C". However I will give it a shot!

They want a Worksheet that is going to require 426 to 434 Columns. First
Question: Is that possible?

Second Question (This might be an Excel Programming Question?) When the tell
me something is in Column HP, how can I confert that to the Field (Column)
Number?

Thanks for Assistance

Len