Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread elhechmi eladeb
thanks 2015-05-21 17:18 GMT+01:00 Mustapha LMIDMANI : > 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 : > >> thanks >> yes the problem is what you just said, each time you open the fi

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread Mustapha LMIDMANI
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 : > 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

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread elhechmi eladeb
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: http://familycomputerclub.com/auomatic-date-tim

Re: $$Excel-Macros$$ code vba pour une date automatique

2015-05-21 Thread Mustapha LMIDMANI
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 : > bonjour > je cherche un code vba qui affiche la date dans la cellul