command which returns the position of cell

[Guest]

I have a macro that searches a string in another sheet.
when it finds I have to proceed a series of calculus dependending on its
position.

Does anybody know a command which returns the position of the cell
([rowindex] and [columindex])?

Daniel (Brazil)

 

[Guest]

Hi Daniel,

You can use this:
Sub rowcol_index()
debug.print ActiveCell.Row
debug.print ActiveCell.Column
End Sub

 

[Guest]

Thanks.

Hi Daniel,

You can use this:
Sub rowcol_index()
debug.print ActiveCell.Row
debug.print ActiveCell.Column
End Sub
--

Regards,

Halim

I have a macro that searches a string in another sheet.
when it finds I have to proceed a series of calculus dependending on its
position.

Does anybody know a command which returns the position of the cell
([rowindex] and [columindex])?

Daniel (Brazil)