Referencing another cell in active cell column

[quackdad]

I can reference a cell in the active cell row: Range("F" & ActiveCell.Row).
But I'm having a heckuva time trying to do it for the column. The comparable Range(ActiveCell.Column & "3") - and several other permutations - won't work. What will?

 

[Jonmo1]

The problem is that ActiveCell.Column returns a NUMBER, not a letter.
And the Range function requires column Letter.

Try using Cells, which can use column number or letter.
Cells(Row#, Column# or Letter)
Cells(3, ActiveCell.Column)

 

[quackdad]

Thank you! I've been trying to use consistent references (Range or Cells) so that whoever comes after me will be able to make sense of my code (it's most likely this person will be trying to learn VBA at the same time, just like I'm doing). For that reason, I find using letter references to the columns much less confusing than Cells or Offsets. But sometimes you just got to deal with it. Thanks again.

 

[Jonmo1]

Glad to help, thanks for the feedback.