command which returns the position of cell
 

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)

command which returns the position of cell
 

Hi Daniel,

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

Regards,

Halim


"dspilberg" wrote:

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)

command which returns the position of cell
 

Thanks.

"Halim" wrote:

Hi Daniel,

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

Regards,

Halim


"dspilberg" wrote:

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)