+ Reply to Thread
Results 1 to 5 of 5

Is there a Macro to Go to a cell and select certain text?

  1. #1
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Is there a Macro to Go to a cell and select certain text?

    Hello all. I hope that I'm posting this in the correct location.

    I am working with a spreadsheet that has asterisks in place of text that should be added. The problem is that it is surrounded by HTML code. I need to be able to select the cell, go to, and highlight the text, where I can hit delete, or just start typing to replace the asterisks, BUT NO OTHER TEXT IN THAT BOX CAN BE EDITED.

    Attached is an example of what I'm wanting to replace.

    example 1.jpg

    I want to create a macro that will go to the text I have highlighted here, and STOP just how this is, so I can simply put what I want in place of the asterisks, and move to the next cell.

    Is this possible?

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Is there a Macro to Go to a cell and select certain text?

    no jpg please, but xls file
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Is there a Macro to Go to a cell and select certain text?

    Adam GEN-058 - Copy.csv

    I hope this helps

  4. #4
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Is there a Macro to Go to a cell and select certain text?

    The asterisks are basically a placeholder. Let's say I'm in cell A7. I want to be able to run a macro that goes to B7, opens the formula, and goes to the asterisks, selects them, and then stops. From there I want to be able to either enter the text I want over the asterisks, or just hit Tab and leave them if I don't need to add any text.

    Is that making any sense?

  5. #5
    Registered User
    Join Date
    05-18-2014
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Is there a Macro to Go to a cell and select certain text?

    Bump. Someone please help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-04-2014, 01:57 PM
  2. Macro to Find Matching text in a cell and select a specif cell
    By Carolynsdesk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2013, 07:28 AM
  3. Replies: 1
    Last Post: 01-25-2013, 12:44 AM
  4. [SOLVED] Select and copy text after specified word macro
    By pongi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-09-2012, 08:11 AM
  5. Macro will not select new text to search for when run
    By -ftp- in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2012, 12:44 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1