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