Copying data relevant to the position of a cell on another sheet

  • Thread starter Thread starter Darren Elsom
  • Start date Start date
D

Darren Elsom

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
 
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.
 
Back
Top