or
cells(1,1).end(xldown).row

--
Don Guillett
SalesAid Software

"Pierre Laporte" wrote in message
...
i dont want the activecell but the cell with the highest row number that
has a value

"Don Guillett" wrote in message
...
I don't quite understand the question but

myrow=activecell.row
mycol=activecell.column


--
Don Guillett
SalesAid Software

"Pierre Laporte" wrote in message
...
I need to know in visual basic what is the row number and column number
of the cell that is used with the highest row and column number.

__________________________________________________ ________________
Pierre Laporte