Reply to thread

Message: [QUOTE="AndreasHermle, post: 6456111"] Dear Experts: I wonder whether the following is possible using VBA: 1. Search for the word 'Sales' on the current worksheet 2. If found then the following action has to be performed (This has been recorded using the macro recorder) Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select 3. The range has to be named 'range1' 4. The macro goes on searching for all instances of 'Sales', repeating the named range creation as described under Point 2 and the 3 5. the range name's number is to be incremented by 1, i.e. range1, range2, range3 etc. Help is much appreciated. Thank you very much in advance. Regards, Andreas [/QUOTE]