How to Find the Column address from a Range Dimensioned Variable

[Ironhydroxide]

I am trying to use a Range demensioned variable as a column address in a
..Cells(... command to give another variable a cell address.

It Looks a little Like THis

DescriptionP3 = Sheets("5-year Plan").Cells(LoopedRowFrom, GeneralDisc.Column)

I am Fairly certain that the problem is with the GeneralDisc variable.

Thanks for all Suggestions

 

[Jacob Skaria]

Hope the below examples will help. .Column and .Row returns the column and
row of the first column and first row in the range

Example :
Set myRange = Range("A1:E20")
myRange.Column will return 1
myRange.Row will return 1

Set myRange = Range("E1:E20")
myRange.Column will return 5
myRange.Row will return 1


If this post helps click Yes

 

[Ironhydroxide]

FOund out myself, (yours sounded a little too bookish)


With GeneralDisc
.Select
BetweenGeneral = ActiveCell.Column
End With

DescriptionP3 = Sheets("5-year Plan").Cells(LoopedRowFrom, BetweenGeneral)

I didnt realize that i had to go through another step to do this. i figured
it could calculate it in the .Cells( , ) command.