+ Reply to Thread
Results 1 to 5 of 5

If cell has strikethrough, state true in adjacent column

  1. #1
    Registered User
    Join Date
    02-05-2019
    Location
    Sydney, Australia
    MS-Off Ver
    2016
    Posts
    2

    If cell has strikethrough, state true in adjacent column

    Hi there,

    This is my first post here!
    I'm new to VB, I've trawled the net, but can't seem to find a solution to my problem.

    Column A contains 4000+ numerical values, some of which have strikethroughs.
    I'd like Column B to flag a TRUE/FALSE if there is/isn't a strikethrough in the corresponding A column.

    This is what I've come up with... although something is off and I can't figure out what.

    Any help would be greatly appreciated!

    Please Login or Register  to view this content.
    Last edited by megametro; 02-06-2019 at 08:40 PM. Reason: added code bookends

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: If cell has strikethrough, state true in adjacent column

    Try

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: If cell has strikethrough, state true in adjacent column

    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

  4. #4
    Registered User
    Join Date
    02-05-2019
    Location
    Sydney, Australia
    MS-Off Ver
    2016
    Posts
    2

    Re: If cell has strikethrough, state true in adjacent column

    Thank you Trevor.

    Unfortunately, column B displays 'FALSE' regardless if there is strikethroughs or not...
    Do you have any idea why this may be? It's puzzling me.

    Thanks again,

    Luke

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: If cell has strikethrough, state true in adjacent column

    Try
    Please Login or Register  to view this content.

+ 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. [SOLVED] Copy Cell Value if adjacent is true
    By rxk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-24-2018, 12:39 AM
  2. Run-time error 1004: strikethrough = true
    By jw01 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2018, 10:44 AM
  3. [SOLVED] Lookup State Name from State Code and and Display in column in COUNTIES worksheet.
    By Jim15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2014, 02:41 PM
  4. Index and Match Only If Adjacent Cell Value is True
    By Duggerz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2013, 07:29 PM
  5. Replies: 1
    Last Post: 09-11-2011, 03:53 PM
  6. Replies: 4
    Last Post: 04-09-2011, 02:51 PM
  7. How to Pick Value of adjacent cell when Search is true
    By tushar@excel in forum Excel General
    Replies: 3
    Last Post: 08-11-2008, 12:36 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