Re: $$Excel-Macros$$Help with macros automatic formulas.

2011-02-03 Thread Hector Ruiz
Thank you Umesh for helping me with the solution ... I use Excel 2007 in Spanish. Regards Hector Ruiz 2011/2/3 Umesh Dev > Hi Hector, > > Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you > have mentioned is esblanco > > > Regards > Umesh Dev > > On Thu, Feb 3, 20

Re: $$Excel-Macros$$Help with macros automatic formulas.

2011-02-02 Thread Umesh Dev
Hi Hector, Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you have mentioned is esblanco Regards Umesh Dev On Thu, Feb 3, 2011 at 2:01 AM, Hector Ruiz wrote: > Hi all, I made a macro to do a consultation with automatic cell ranges, > with letters running but when t

Re: $$Excel-Macros$$Help with macros automatic formulas.

2011-02-02 Thread Peter Konijn
Hi, Coild the problem be the fact that the calculation option is on manual? Greets Peter 2011/2/2 Hector Ruiz > Hi all, I made a macro to do a consultation with automatic cell ranges, > with letters running but when the result is number does not work, I have > to double click to run the Forumu