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...