Hi
I am trying to search for a value, then find if its formatted with strikethrough.
I have VBA code to return the confirmation that its strikethrough:
Function StrikeThru(rng As Range)
StrikeThru = rng.Font.Strikethrough
End Function
=StrikeThru('BAU List'!A58) -- Comes back TRUE
I am trying to search for a site name (column A) on another sheet
=VLOOKUP(A2,'BAU List'!A:A,1)
This finds the cell, but i need to to return a TRUE value on the VLOOKUP if its strikethrough
I have tried various things but nothing is working.
please help.
Many thanks
I am trying to search for a value, then find if its formatted with strikethrough.
I have VBA code to return the confirmation that its strikethrough:
Function StrikeThru(rng As Range)
StrikeThru = rng.Font.Strikethrough
End Function
=StrikeThru('BAU List'!A58) -- Comes back TRUE
I am trying to search for a site name (column A) on another sheet
=VLOOKUP(A2,'BAU List'!A:A,1)
This finds the cell, but i need to to return a TRUE value on the VLOOKUP if its strikethrough
I have tried various things but nothing is working.
please help.
Many thanks