Re: Can we use "*" to replace string in VBA excel macros ?

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/10/05


Date: Thu, 10 Feb 2005 15:56:26 -0500

The example I gave would produce where the string is found. As long as it
isn't zero, you would copy. I am not sure why you can't make it. The
example needs no interpretation - When the condition is passed, you copy.

-- 
Regards,
Tom Ogilvy
"Tomek" <tomolder28@gazeta.pl> wrote in message
news:cugdtk$973$1@inews.gazeta.pl...
>
> 1) If one string is in the begining of other string
> 2) if one string is in the middle of other strings
> 3) if one string is in the end of other string
>
> if the string is found in the above situations I would like to have it
> coppied and  offset(0,1)
>
> I can't make it !!!
>
> Thank you very much for help
> -- 
> Tomek


Relevant Pages

  • Re: How to get path to current directory?
    ... Tomek wrote: ... From the OS/2 WARP v4.5 Desktop of Brad BARCLAY. ... The jSyncManager Project: http://www.jsyncmanager.org ...
    (comp.lang.java)
  • Re: macro extracting text
    ... one of the string is the same as in A column. ... I hope it is clearer now. ... Thank you very much for your patience. ... Tomek ...
    (microsoft.public.excel.programming)
  • REPRESENT revisited
    ... Forth-94 has few floating point display functions [none in the ... If u is greater than zero the character string shall consist ... If u is zero the string shall consist of one digit representing ...
    (comp.lang.forth)
  • Re: Reproducing java calculations in UNIX
    ... quotient goes in x, also a double. ... is greater than zero) only the fractional part of the ... {fraction is 52 zero bits, ... is converted from string to floating point (string ...
    (comp.unix.shell)
  • Re: REPRESENT revisited
    ... >has given rise to implementations that differ in critical ... The required compatibility is 1), but 2) makes it much easier to get ... > If u is zero the string shall consist of one digit representing ... But I think it is a very bad idea if a word that should fill a string ...
    (comp.lang.forth)