Hi all
My problem is not very easy. That's why i don't know if i am on the good topic. I hesitated between the three topics: miscellaneous, general and programming. I will be long and forgive me. So, i begin. I have created some files with macros. What i want to do is to find an instruction. For example, on my file called example.xls, i have the following macro:
Selection.Sort Key1:=Range("B1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, Orientation:=xlTopToBottom
ActiveSheet.Range("B1").End(xlDown).Offset(1, 0).Select
'Select the first empty cell in the column
ActiveCell.Offset(-1, 0).Select
Later, i want to create a new file with a macro and i want to select the first empty cell in the column. Then i need to use the good instruction. But i don't know it. In fact, i'm not a great programmer. Then i want to search it in my files thanks to the explorer with Ctrl+F. In the explorer, i write: "select the first empty cell in the column". I fact i want to find:"ActiveSheet.Range("B1").End(xlDown).Offset(1, 0).Select".The problem is that the macros are hidden. If i have the following text in the cell A1: "Box". In the explorer, i write "box" and the explorer shows me all results or all files with the text "box". But if i write "select the first empty cell in the column", there's no result because this instruction isn't in a cell but in a macro. Is there a method to find an instruction in a macro. Of course, i have many files and i don't remember. I hope be clear
Thanks in advance.
Bookmarks