Affiliate Marketing
Forum Search

Reply
 
LinkBack Thread Tools Display Modes

  #1 (permalink)  
Old 15-08-06
HairyCornflake's Avatar
changing website again...
 
Join Date: Oct 2005
Posts: 163
Thanks: 0
Thanked 0 Times in 0 Posts
HairyCornflake is an unknown quantity at this point
  Excel Macro - Locating Text In Cell

Hi All

I'm trying to create an Excel macro that will look in a cell's contents and identify which (out of many) phrases it contains.

For example, look in cell and see if
=baa baa black sheep or,
=mary's lamb or,
=three blind mice

are within that cell - anywhere in that cell.

I'm sure that left, mids, right would do the job. But with the text being possibly anywhere in the cell - can't quite figure out the macro code.

Would appreciate any assistance.
__________________
Free Mobile Phone Tariff Calculator For Your Customers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 15-08-06
lakrasia's Avatar
Dot Com Pennyaire
 
Join Date: Jan 2004
Location: this month, Guatemala
Posts: 626
Thanks: 0
Thanked 0 Times in 0 Posts
lakrasia is an unknown quantity at this point
use search

e.g. SEARCH("mary's lamb",A8,1)

If the text is contained in the cell, it will return its position
__________________
I used to have an open mind but my brains kept falling out.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 15-08-06
HairyCornflake's Avatar
changing website again...
 
Join Date: Oct 2005
Posts: 163
Thanks: 0
Thanked 0 Times in 0 Posts
HairyCornflake is an unknown quantity at this point
Cheers,

but does this work in a macro? I can get it to work fine as a formula but can't get it to work in a macro?

Thanks
__________________
Free Mobile Phone Tariff Calculator For Your Customers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 16-08-06
lakrasia's Avatar
Dot Com Pennyaire
 
Join Date: Jan 2004
Location: this month, Guatemala
Posts: 626
Thanks: 0
Thanked 0 Times in 0 Posts
lakrasia is an unknown quantity at this point
I don't know - maybe you can click on 'record macro', and type the code into the cell and then look at the macro to get the code?
__________________
I used to have an open mind but my brains kept falling out.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
LG Chocolate phones2udirect Affiliate Future 1 02-06-06 05:39 PM
LG Chocolate phones2udirect Affiliate Window 1 02-06-06 05:38 PM
Dell text link will 68 TradeDoubler 2 12-08-03 04:42 AM


Affiliate Marketing RSS Feeds - Contact Us - Affiliate Marketing - Archive - Privacy Statement - Top

Content Relevant URLs by vBSEO 3.2.0 RC7