+ Reply to Thread
Results 1 to 4 of 4

Trying to create code that selects part of a cell and does a strikethrough

  1. #1
    Registered User
    Join Date
    11-12-2013
    Location
    NM
    MS-Off Ver
    Excel 2003
    Posts
    2

    Trying to create code that selects part of a cell and does a strikethrough

    The cell includes: 1 <-old-|-new-> 2

    With this I can select the length from 1 to 2:

    Please Login or Register  to view this content.
    However, how do I select start 1 to right before the "<-old-|-new->"

    Once I have that I will then delete "<-old-|-new->"

    Thank you for your help. Im a beginner trying to figure this out.

  2. #2
    Registered User
    Join Date
    11-12-2013
    Location
    NM
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Trying to create code that selects part of a cell and does a strikethrough

    The reason why I need to get the data between start 1 and <-old is because the size of the data between that can change.

  3. #3
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Trying to create code that selects part of a cell and does a strikethrough

    Please Login or Register  to view this content.
    Error handling would be needed in case the '<' does not exist.

  4. #4
    Forum Contributor amit.wilson's Avatar
    Join Date
    07-09-2013
    Location
    Gotham
    MS-Off Ver
    Excel for Mac 2011
    Posts
    283

    Re: Trying to create code that selects part of a cell and does a strikethrough

    Hi, try this:

    Please Login or Register  to view this content.
    It strikes through the text starting from < to >. Is that what you are looking for?

    Cheers
    <-- If you're happy & you know it...click the star.:-)

+ 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: 2
    Last Post: 03-09-2013, 04:30 AM
  2. Strikethrough code to activate when end date is past.
    By Zyphon in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-27-2012, 07:04 AM
  3. [SOLVED] Create a Macro for copying data from one cell and pasting into certain part other cell
    By Paul M in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-03-2012, 10:17 AM
  4. Code selects entire rows upto one range and same code selects only columns for other.
    By sriharigk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 05:19 AM
  5. How to create a forumla that selects the right most column, and bottom-most cell
    By JFarris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2009, 12:11 PM

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