Using the macro record button on a sheet with data I wanted to find text in the multiple rows, first start the macro recorder ctrl+f enter the text, find all and then do a ctrl+a in the find window and all the rows with that text is selected, I then close the find dialogue box [doesn't make a difference if I close the find box] and under the home tab for cells I click the delete down arrow then click delete sheet rows, the rows are deleted I hit ctrl+home and Stop the macro recorder and using Alt F11 open the newly created macro module and there is no ctrl F recorded.
What am I doing wrong??
gazza
What am I doing wrong??
gazza