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