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: 4
Default Find a String

Hi, I have this problem:

I need to check, whether in a cell there is or not string, beginning
with "Access" I tried to make a macro, but I am not able to do it...

Example of text in cells:
Calls to Eurotel
Calls to Orange
Access No. 45687
Local Calls
Access No. 15789
Calls to Orange
Calls to Eurotel
Access No. 78896

I tried to write a code like:

Sub Check()
Dim MyString As String
Do
MyString = ActiveCell.Value
If MyString = "Access*" Then
MsgBox "I've found one!"
End If
ActiveCell.Offset(1, 0).Select
Loop Until MyString = "Access*"
End Sub

Any idea please?

Marian

 
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
Find in string Arne Hegefors Excel Worksheet Functions 2 January 26th 07 08:50 AM
Find String in another string - only between spaces Nir Excel Worksheet Functions 9 November 2nd 06 11:31 AM
Find Many String options in ONE String Nir Excel Worksheet Functions 6 October 26th 06 07:13 AM
find string within other string Nir Excel Worksheet Functions 8 October 25th 06 11:27 PM
find nth position of a string TUNGANA KURMA RAJU Excel Discussion (Misc queries) 6 October 18th 05 01:25 PM


All times are GMT +1. The time now is 11:42 AM.

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"