LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 417
Default problems recording macro_value or formula?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
aauugghhh...#div/o problems & various average formula problems acbel40 Excel Worksheet Functions 5 October 19th 09 05:00 PM
formula problems LoveExcelButFrustrated Excel Discussion (Misc queries) 4 June 11th 08 08:51 PM
recording macro for a formula timmulla Excel Programming 3 November 26th 07 04:11 PM
How do I make the Stop Recording bar pop up when recording macros J Excel Worksheet Functions 1 January 10th 06 08:46 PM
recording macro to paste a copied ws formula Peter[_21_] Excel Programming 2 December 11th 04 09:36 PM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"