View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dspilberg dspilberg is offline
external usenet poster
 
Posts: 32
Default 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)