Results 1 to 5 of 5

If cell has strikethrough, state true in adjacent column

Threaded View

  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!

    Option Explicit
    
    Sub strikethrough()
    Dim i As Integer
    i = 1
    
    Do While Cells(i, 1).Value <> Cells.Font.strikethrough = True
    Cells(i, 2).Value = "FALSE"
    i = i + 1
    Loop
    
    
    End Sub
    Last edited by megametro; 02-06-2019 at 08:40 PM. Reason: added code bookends

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