Hello all, I have a macro that looks in A and finds a name, then finds a word of text in a cell the copies information. I would like it to keep finding the word cells until it reaches another word cell: Example: Code: Cells.Find(What:="Bob", After:=ActiveCell).Activate Cells.Find(What:="Inbound", After:=ActiveCell).Activate ActiveCell.Offset(0, 2).Range("A1").Copy ActiveCell.Offset(0, 16).Range("A1").Select ActiveSheet.Paste ***this ia where i want it to go to*** do this command above until it finds the word 'Wrokgroup' Can anyone help? Adrac
This question generated 27 answers. To proceed to the answers, click here.