VBS Code to exclude Strikeout

[Debbiejj]

Hi Everyone,

Im new here and have looked for an answer for VB to identify cells that do not have strikethrough applied. For example, In column A there are prices listed, some are old prices. The newer price is listed in the cell below. In column B, I want to insert a Y if there is no strikeout in the corresponding cell in column A.

Does anyone know how I can accomplish this?

Thank you in advance and have a great day,

Debbiejj

[mehmetcik]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[maniacb]

Try this code in a module.

Please Login or Register  to view this content.

[Debbiejj]

Thank you very much. I appreciate you helping me. I used the code, but cant seem to get the right formula to use in the column that I want to include the Y. I don't have any experience with VB and am trying to learn through application.

thanks again Debbie

[mehmetcik]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Debbiejj]

Thank you, I’ll try this, could you please let me know what the formula should be in cell B1?

[maniacb]

There are no formulas with this VBA solution. Here is a working file. If you need instructions how to apply it to your working file, either upload your file or let us know.

[Debbiejj]

This worked perfectly! Thank you so much.