Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search for StrikeThrough in Excel

Status
Not open for further replies.
jcw5107

jcw5107

Technical User
Jan 31, 2007
66
0
0
US
I need to be able to select a column (column B), and for each cell that has a "strikethrough", update the cell in column C (next to the "strikethrough" cell) to "UC"..

Can't find anything posted regarding this...
Thanks in advance...!!
jcw5107
 
Sort by date Sort by votes




Hi,

Turn on your macro recorder and record formatting a strikethru value.

Post back with your code in Forum707, for assistence with making a User Defined Function (UDF) that you can use on your sheet.

Skip,
[sub]
[glasses] When a wee mystic is on the loose..
It's a Small Medium at Large! [tongue][/sub]
 
Upvote 0 Downvote
SkipVought,

I posted back in form707...
I hope I did it right....
Look for "Search for StrikeThrough in Excel"...


Thanks..
jcw5107
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
495
Andrzejek
Andrzejek
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
150
SkipVought
S
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
141
combo
combo
Bijugate
  • Question
Excel update question
Replies
0
Views
100
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
128
combo
combo

Part and Inventory Search

Sponsor

Back
Top