if a user selects row 39 that is the row of the activecell.

myrow=activecell.row

However it sounds like you could do away with most/all selections. post your
code for comments.

--
Don Guillett
SalesAid Software

"Darren Elsom" wrote in message
...


I have a sheet with 80 rows of data.

The user selects a cell in the first column of the table of data. The
macro
then confirms the cell is within range and allows the row contents to be
deleted.

So far so good.

Another sheet is then selected where i need to replace the data on a
specific line with formulas that are hidden elsewhere on the sheet.

My problem is, if the user selects say row 39, how do i select row 39 on
the next sheet.

Any help will be greatley appreciated

Thanks in advance