Thread: [Solved] show a cell
View Single Post
 
Old 05-23-2012, 12:55 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,344
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
In that case, it shouldn't matter that the last two characters may appear in more than one location (there is still one character not accounted for); what matters is that the overall string being searched for is unique.

Try replacing '.Cells(i, 2).Value' with 'Right(.Cells(i, 2).Value,8)'
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote