I have code for erasing data after I enter certain data in a cell then hit my button to execute the code. It works great.
Right now, whatever I enter in Cell A1. I want to change it to THE CURRENT CELL I'M IN. How do I write in code... the current cell

ie: Set Criteria1=Range("A1") I need to change A1 to current cell?? How?

Thank You,
Michael