little mistake,, but now done
=IFERROR(TRIM(CONCATENATE(MOC
,MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
I have been looking for the same !!!
Regards,
Mandeep Baluja
On Thursday, May 21, 2015 at 11:01:39 AM UTC+5:30, Priti_Verma wrote:
Hi There,
Is there any job for vba developer.
Thanks
Priti
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Practice can teach you excel, because nobody knows the end of Excel.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
https://www.linkedin.com/profile/view?id=312532939
On Thursday, May 21, 2015 at 8:21:02 AM UTC+5:30, rahulbhardwaj1986 wrote:
Hi
bonjour
je cherche un code vba qui affiche la date dans la cellule e après qu'on a
saisie les données dans le cellule a b c d et que cette date soit fixe et
ne change pas avec le temps.
merci pour l'aid
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
thanks
yes the problem is what you just said, each time you open the file the date
changes. in this case I find a vien code in Internet. the problem that
execute from i = 2 to i = 100 beyond the 100 code is not working. the code
you find in this link:
Please try to use function now() it gives the actual date and hour when
you write it. but it will updated each time you open the file ... and this
is not what you're looking for I think...
2015-05-21 16:43 GMT+01:00 siga eladebelhec...@gmail.com:
bonjour
je cherche un code vba qui affiche
without reading in deep of the code, you can just give to i a verry big
value this will solve your issue ?
2015-05-21 17:12 GMT+01:00 elhechmi eladeb eladebelhec...@gmail.com:
thanks
yes the problem is what you just said, each time you open the file the
date changes. in this case I find a
thanks
2015-05-21 17:18 GMT+01:00 Mustapha LMIDMANI lmidmani.musta...@gmail.com:
without reading in deep of the code, you can just give to i a verry big
value this will solve your issue ?
2015-05-21 17:12 GMT+01:00 elhechmi eladeb eladebelhec...@gmail.com:
thanks
yes the problem is
maybe someone will need
http://training-course-material.com/training/Visual_Basic_for_Applications_(VBA)_in_Excel_-_Introduction_to_programming
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @