Microsoft Office Questions? Ask a IT Expert for Support ASAP
Would you be able to send me the file with the macro so I can set it up for you. To do so go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
If the file has sensitive information let me know before you upload it
Ok here is the stand-alone code for that
Sub ConvertDBR()Set Rng = ActiveSheet.UsedRangeFor Each cell In RngIf cell.HasFormula = False Then GoTo 111If InStr(cell.Formula, "DBR") > 0 Thencell.Value = cell.ValueEnd If111Next cellEnd Sub
Hope this ok. Thank you for rating this answer "Excellent" or "Good" so I get credit for my work. I will continue to assist if you still need help