You should specify the problem more.
2013/8/24 xlstime
> what we can do?...both workbooks VBA coding is password protected
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Fri, Aug 23, 2013 at 7:33 PM, Sanjay Mandal <
> sanjaykumarmanda...@gmail.com> wrote:
>
>> Dear all
>>
>> MI
what we can do?...both workbooks VBA coding is password protected
.
Enjoy
Team XLS
On Fri, Aug 23, 2013 at 7:33 PM, Sanjay Mandal <
sanjaykumarmanda...@gmail.com> wrote:
> Dear all
>
> MIS Details 2013 to 2014 IN* CALL USERFORM* DAILY TRANSFER SHEET-13
>
> *Regard
Just figure it out after someone asking it again in another groups
Using Indirect in Defined Name to make it dynamic Row, but just work for
Column A :-D
=EVALUATE(INDIRECT("A" & ROW()))
On 30-07-2013 14:01, xlstime wrote:
if we have more then thousands of records than?
Hi Pavan, Try this rev code
Function xSum(ParamArray Numbers()) As Variant
Dim BlockRange, SingleRange, Buffer
For Each BlockRange In Numbers
If WorksheetFunction.IsNumber(Evaluate(BlockRange)) Then
Buffer = Buffer + BlockRange
Else
For Each SingleR
PFA with solution
Regards,
Waseem Saifi
On Fri, Aug 23, 2013 at 12:36 PM, ravinder negi wrote:
> PFA
>
> --
> *From:* Ali Abbas
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, August 22, 2013 9:01 PM
>
> *Subject:* $$Excel-Macros$$ Sum if array for cut
PFA
From: Ali Abbas
To: excel-macros@googlegroups.com
Sent: Thursday, August 22, 2013 9:01 PM
Subject: $$Excel-Macros$$ Sum if array for cut dates
Date: 1 2 3 4
Amount: 100 200 300 400
Now formula working.
We can calculate value with arr
