command which returns the position of cell

's Computer Specifications

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)

's Computer Specifications

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)

's Computer Specifications

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)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data shape command text contains a syntax error at or near position 106 in the command.	Bob	Microsoft Access ADP SQL Server	3	14th Apr 2008 09:43 PM
GPS always returns the same position	Star	Microsoft Dot NET Compact Framework	1	11th Dec 2007 07:23 PM
Mouse Position/Command button position	=?Utf-8?B?RkJ4aWlp?=	Microsoft Access VBA Modules	1	17th Jul 2006 07:15 PM
Re: In macros, an instruction that returns the position of the Active Cell	Roger Govier	Microsoft Excel Discussion	1	20th Jan 2006 02:54 PM
What function returns the Nth position in a sequence of numbers?	Shiperton Henethe	Microsoft Excel Discussion	4	19th Nov 2004 12:27 PM