ActiveCell.Column()?

[davidam]

Can some tell me why this:

Range("a1").Value = Range("C" & ActiveCell.Row()).Value

Works,

and this:

Range("a1").Value = Range(ActiveCell.Column() & "9").Value

does not? And... can I make it work somehow?
Thanks,
David

 

[AlphaFrog]

ActiveCell.Column returns an integer and the Range statement is expecting a column letter.

This should work.

Range("A1").Value = Cells(9, ActiveCell.Column).Value

Note: the () are not needed after .Column or .Row

 

[davidam]

Works perfect. I never heard of this before and I had to look it up...the Cells Property. The more I know....
Many thanks!
David
PS Thanks for the tip on the (). D.