Hello,
I need help with the following Macro. When the button is clicked I need the code to set focus (make active cell) on the cell the button is on allowing rows to be inserted and with the button always setting focus on the same row as the button is on.
My example only references Cell "F9" instead of always referencing the cell the button is on.
Sub InsertCopyRowClearContents2()
ActiveSheet.Range("F9").Select
ActiveCell.Offset(1, 0).EntireRow.INSERT
ActiveCell.EntireRow.Copy ActiveCell.Offset(1, 0).EntireRow
ActiveCell.Offset(0, 0).Select
Selection.ClearContents
ActiveSheet.Range("F9").Value = "Enter Below"
ActiveSheet.Range("F10").Select
End Sub
Please provide the code if possible.
Thanks, Marc Bailey
Bookmarks