POSITION OF THE ACTIVE CELL

[gab]

Hi!!!

Please a need some help...How do I know a position of the active cell (rows and columns) using vba code and putting the row and column value into variables, as let's say X and Y?? Thanks for your answer!

 

[jindon]

MsgBox "ActiveCell.Row = " & ActiveCell.Row & vbLf & _
       "ActiveCell.Column = " & ActiveCell.Column

 

[gab]

IT WORKS........THANKS !!!!!!!!!!!!!!!!!!!!!!!