Message-
From: Jaideep Panchal
Sent: Wednesday, September 19, 2012 10:09 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
I agree with you Don,
However, there are around 2500 sites and I need to put SUM formula to
@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
If speed is a consideration with a LARGE database, you will find that my
solution is much faster, And, why go to the trouble of using a macro to add
the sums and then leave the formula??? However
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Wednesday, September 19, 2012 8:20 PM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Use this INSTEAD
acros@googlegroups.com]
On Behalf Of dguillett1
Sent: Wednesday, September 19, 2012 8:20 PM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Use this INSTEAD
Sub GetSumsSAS()
dim lr as long
Dim c As Range
Dim
ooglegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jai Deep
Sent: 19 September 2012 4:07
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Rajan/Swapnil,
Thanks a lot for your code…. I need one more
Sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Jai Deep
Sent: Wednesday, September 19, 2012 5:36 AM
To: excel-macros@googlegroups.com
Cc: Jai Deep
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy b
gFrom.Address & ":" &
rngTo.Address & ")"
End If
Next rngCell
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jai Deep
Sent:
-macros@googlegroups.com]
On Behalf Of >>Excel Beginner<<
Sent: Friday, September 14, 2012 9:25 PM
To: excel-macros@googlegroups.com
Cc: jai_d...@msn.com
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Jaideep,
ple
@googlegroups.com
Subject: RE: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Would it be helpful for you??
Sub MTest()
Dim rngRange As Range
Dim rngCell As Range
Dim rngFrom As Range
Dim rngToAs Range
Set rngRange = Range(&quo
:19 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to put sum formula automatically - seems
easy but not so
Hi Jaideep,
This is one time activity. I have create on macro to automatically put
formula for Each site, it will apply sum formula for each site.
Attached
Next rngCell
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of >>Excel Beginner<<
Sent: 14 September 2012 9:25
To: excel-macros@googlegroups.com
Cc: jai_d...@msn.com
Subject: Re
Am I not getting the problem correctly or is it very simple ?
Use this:
Sub PutSum()
Range("rngSum").Formula = "=Sum(I2:I" & Range("rngSum").Offset(-1).Row &
")"
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros
Can u please explain it more ?Not understood
On Fri, Sep 14, 2012 at 11:16 AM, Jaideep Panchal wrote:
> Hi group,
>
> ** **
>
> ** **
>
> I need some help in putting sum formula and hope u all will provide a good
> help as always…..
>
> ** **
>
> ** **
>
> I am attaching a sheet in which
13 matches
Mail list logo
