Reply to thread

Message: [QUOTE="andrei, post: 6448097"] In A column i have many cells with text . Sometimes cells with text , sometimes empty cells . From time to time consecutive cells ( like A5 and A6 or A5 , A6 , A7) have the same keyword . I want the macro , in this case, to delete the rows , keeping only the first one in a series of consecutive cells . I give an example Let's say the kwyword is "mother" A1: mother goes home A2: empty A3: mother and father A4: my son and my mother A5: My mother is sick A6: Gather some .... A7: empty cell The result should be : A1: mother goes home A2: empty A3: mother and father A4: Gather some... A5: empty cell Many thanks [/QUOTE]