Spaltenbuchstabe selber definieren

[TobiasTokio]

Hello again,

now my problem is:
I want to read out a value from a cell. For example "J".
Now I want to use this value as an Column letter for a range in my macro code.

something like this:

Dim Column As String
'Read out the right column
Column = Workbooks("Spiridon_result_transfer_en (4).xls").Worksheets("final").Range("O10").Value

'Select right Data
Range(Column &  "5":Column + "7").Select

but like you see this is not working
maybe sb. can help me....
thx

 

[Nirraven]

Gibts das auch auf Deutsch? ;-)

P.S.:

Sub test()
Dim Column As String
'Read out the right column
Column = Range("A1").Value
Column = Column & "5:" & Column & "7"

'Select right Data
Range(Column).Select
End Sub

 

[TobiasTokio]

naechstes mal wieder....

vielen dank fuer deine hilfe!