Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Your country settings are preventing me from clearly seeing what you are
doing. I am seeing character 161 in your # DIV/0! values in the data you posted. <<Ican see now, you don't receive my messages with attached files. I don't believe that the newsgroups allow attachments. <<#1Div/0 is always a subtota(1; )formula. I get "#DIV/0!" for an error value in a cell that has an error. How does the "1" show up in your (Spanish?) version? Your "replace6" routine simply checks to see if the first character in the cell value is a "less than" ("<") symbol (?). I don't understand what you are trying to do. Routine "replace5" loops forever, without end. All I can suggest at this point is to turn on the macro recorder while editing one of the cells that you want to change, then look carefully at the result to incorporate it into the loop in your routines (or post the recorded code in the newsgroup). -- Regards, Bill Renaud |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
formula problems | Excel Discussion (Misc queries) | |||
recording macro for a formula | Excel Programming | |||
How do I make the Stop Recording bar pop up when recording macros | Excel Worksheet Functions | |||
recording macro to paste a copied ws formula | Excel Programming |