What is the format for selecting a row to delete? The
problem is the row that needs to be deleted will change.
The good news is that the activecell in column A will
always be on the row that needs to be deleted. Is there a
way to go ahead and tell Excel to highlight the row that
the activecell is on and delete? Below is the basic code
for deleing a row, however it specifies the row directly.
What do I need to change?

Rows("1:1").Select
Selection.Delete Shift:=xlUp