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.
Hi smithan04
Please wrap your code in code tags, before the moderators get you...
Click here - Forum rules
Cheers3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks