Find and Move a specific cell
Posted by Sebastien on September 28, 2001 6:11 AM
I'm importing data from a text file, with no way to filter it correctly.
I need to find a specific word and then to move the corresponding cell upper...
I'm able to do this action for the first occurence, I need that the VBA macro do all the sheet ! Please Help Me !!!
I've tried a lot of way (to filter, data sort), but no way.
Here is my code :
For i = 1 To 145
Cells.Find(what:="*ms", lookat:=xlPart, searchorder:=xlByRows, MatchCase:=False).Activate
When macro tries to find the next occurence, it find the same cell, and so on...
Thanks in advance for your help