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: 1,045
Default Replacing the formula text's substring

On Fri, 7 Oct 2011 22:27:06 -0700 (PDT), parahumanoid wrote:

It's only a matter of my poor translation. I'm using a Russian
localized version, so there is another variable name used instead of
ThisWorkBook. And it apparently "kind of" works because if I put a
MsgBox inside the loop it fires the expected number of times (the
number of formula cells on the active sheet), but the replacement,
regardless of the "True" state of the Replace function's result, does
not occur. Could it be that I never turned the screenupdating back on?


I think that would be unlikely. Screenupdating will get turned back on when you exit the Macro anyway.

Check to ensure that you are really using the Replace method of the Range object in Russian.


 
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
How do I concatenate text to keep the text's original color/font/s Temp_User Excel Discussion (Misc queries) 1 September 12th 05 10:12 PM
Replacing formula James[_26_] Excel Programming 2 August 11th 04 03:10 AM
Replacing Formula James[_26_] Excel Programming 2 August 9th 04 09:30 PM
Replacing a value from a formula Squid[_2_] Excel Programming 1 February 14th 04 02:02 PM


All times are GMT +1. The time now is 04:12 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"