Getting the row/column number
 

Hi,

How can I get the row and column number into variable x to use it late
on in the mcaro?

Thank

--
micha
-----------------------------------------------------------------------
michal's Profile: http://www.excelforum.com/member.php...fo&userid=2440
View this thread: http://www.excelforum.com/showthread.php?threadid=38006

Getting the row/column number
 

the row and column number of what?

If row number and column number of selected cell

it is

dim x1,x2 as variant
x1=Selection.Row
x2=Selection.Column


if you want row number and column number of a cell


dim x1,x2 as variant
x1=range("ab10").Row
x2=range("ab10").Colum

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=38006

Getting the row/column number
 

That is great. Thank

--
micha
-----------------------------------------------------------------------
michal's Profile: http://www.excelforum.com/member.php...fo&userid=2440
View this thread: http://www.excelforum.com/showthread.php?threadid=38006