Re: $$Excel-Macros$$ vba formula vs calculation - problem with "<=" or dates

Dear Mark, Please send your file. On Sat, Jun 2, 2012 at 10:01 PM, dguillett1 wrote: > There may? be a better way to do this. Reply to ME at the address below > with your file. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Mark Kerin > *Sent:*

Re: $$Excel-Macros$$ vba formula vs calculation - problem with "<=" or dates

There may? be a better way to do this. Reply to ME at the address below with your file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Mark Kerin Sent: Friday, June 01, 2012 1:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ vba formula vs calcul

Re: $$Excel-Macros$$ vba formula vs calculation - problem with "<=" or dates

Thank you Noorain. Yes, Evaluate() does put a value in the cell instead of a formuala. That is great. Do you have any idea how to make the equation include "<=" in the last clause? On Friday, June 1, 2012 8:58:42 PM UTC-4, NOORAIN ANSARI wrote: > Dear Mark, > > You can try.. > . > .Range("q"

Re: $$Excel-Macros$$ vba formula vs calculation - problem with "<=" or dates

Dear Mark, You can try.. . .Range("q" & i).Formula = *Evaluate(*"=SUMIFS(O$2:O$26196,A$2:A$26196," & "a" & i & ",N$2:N$26196," & "n" & i & ")"*)* -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sat, Jun 2, 2012 at 12:13 AM, Mark Kerin wrote: > > T