No, unforturnately. The column designator has to be a number, because
it is computed from other variables using math.

Fred Holmes

On Wed, 21 Jan 2009 21:42:01 -0800, FSt1
wrote:

hi
not sure exactly what you are after but is this close????
Sub FredHolmes()
Dim c As String
c = InputBox("enter column letter")
'or
'c = "A"
Range(c & "10").Select
End Sub

hope i guessed good
regards
FSt1


"Fred Holmes" wrote:

Range(A5000) is a valid VBA expression.

How do I specify "A" as a variable?

Range(Columns(n)5000) or something like that?

Where n is an integer column number obtained separately.

The above trial expression returns an error message:

Expected separator or ")" .

But the trial expression has balanced parenthses.

Thanks,

Fred Holmes