Can a vba code be written to find a number/word comb. in a row, whose position changes per row and then copy it into another cell?
Sub Test()
For Each Cell In Selection
If Cell Like "*MV" Then Cell.Copy.Like "*MV"
Next Cell
End Sub
Can a vba code be written to find a number/word comb. in a row, whose position changes per row and then copy it into another cell?
Sub Test()
For Each Cell In Selection
If Cell Like "*MV" Then Cell.Copy.Like "*MV"
Next Cell
End Sub
Last edited by smithan04; 06-17-2011 at 10:36 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks