LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Finding an exact string in a range

Hi all

I really need some help please....

I have list of values in a range of cells

18A
18B
18C
18D
18E
18

There is a string variable called Curr_DU

The line of code reads

Dim Start_Rng as Range
Dim Curr_DU as String


Set Start_Rng = Range ("C2:C50").Find(Curr_DU)

This works great until it hits the last value which is 18 but it then
picks up 18A position. How can I simply change the macro to be
specific on finding 18 but not the others.

Thanks in Advance

John

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding exact date Alex Excel Programming 1 January 2nd 08 11:08 PM
vlookup and finding text string that's not an exact match my Excel Discussion (Misc queries) 4 July 31st 07 05:04 PM
finding exact matches ft1986 Excel Worksheet Functions 3 July 11th 07 09:32 PM
Finding EXACT matches within separate rows IowaTracy Excel Discussion (Misc queries) 5 August 13th 06 06:55 AM
finding exact matches using vlookup Ekazakoff Excel Worksheet Functions 9 July 29th 06 02:24 PM


All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"