I would like to be able to return the row number of the active cell then assign that value a variable. It is saying “Object not Defined” for ActiveCell.Row when I attempt to run the Macro. I would like to have cells copied to another sheet based on the value of the active row.