| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VBA question When I search to replace parentheses in excel it givesme "-" sign
To whom it may concern,
I have this issue with one of my VBA files and I just can't figure it out. I have this search and replace macro that does a good job but I can't figure out why it places a negative (-) sign on values without a space after the parentheses. Your help is greatly appreciated. Start example https://docs.google.com/spreadsheets...it?usp=sharing Finished example https://docs.google.com/spreadsheets...it?usp=sharing Sub Discus_Fix() ' ' Discus_Fix Macro ' Replaces redundant information on Discus AS9102 Report Cells.Replace What:="note: ", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I replace decimals starting with "." to "0." in excel? | Excel Discussion (Misc queries) | |||
| How to perform Search and Replace on "Tilde", CHAR(126), ~ | Excel Worksheet Functions | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
| turn off the " replace file?" question when saving excel files | Excel Programming | |||
| Is there a "replace" or "Substitute" command in Excel's VB? | Excel Programming | |||
Threaded Mode
