I have Excel 97 and have a spreadsheet that contains individuals
results set out in each row. I have a macro which wipes all the info
on the sheet but I need a button located at the start of the
individuals row which allows me to delete just that row. Some of the
cells in each row are protected so, to work around this, I have set up
offsets to select the required cells for me such as -

ActiveCell.Offset(0, 11).Select
Selection.ClearContents
Selection.ClearComments

The problem I am having is that the active cell is the last cell I
entered data into... I cannot find a way to make the active cell the
cell underneath or to the right of the command button I press, hence
data is wiped in the wrong place.

Can someone please shed some light on this problem for me?