cell row and column

[565u]

Hi!

I need to read the location of an active cell, wherever in the worksheet it is. I've been trying to figure this out for eternity.

Could anybody much smarter than me kindly help, please?


Many thanks in advance!!

Pavel

 

[PHV]

Something like this ?
MsgBox ActiveCell.Address

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[AnotherHiggins]

Like this:

variable1 = ActiveCell.Address

?

[tt]_____
[blue]-John[/blue]
[/tt][red]"If you're flammable and have legs, you are never blocking a fire exit."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[Zathras]

Your subject line says row and column, so perhaps something like this is what you are looking for:

  MsgBox "Active Cell: " & ActiveCell.Address & vbNewLine _
          & "Row:      " & ActiveCell.Row     & vbNewLine _
          & "Column:   " & ActiveCell.Column