Hope the attached file can help you better.
Regards,
Anoop
Sr. Developer
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pro
Either you can go for dell or hp
http://www.dell.com/in/p/inspiron-laptops?~ck=bt
http://www8.hp.com/in/en/products/laptops/index.html?facet=Everyday-computing
Regards,
Lalit Mohan
On Wednesday, 9 January 2013 11:21:01 UTC+5:30, .. wrote:
>
> any views / comments folks ?
>
> Also, are there othe
Thanks for your help..
On 8 January 2013 12:56, jmothilal wrote:
> use ((amount* int/100)/365) * no of days
>
>
>
> On Tue, Jan 8, 2013 at 11:43 AM, Hari wrote:
>
>>
>>
>> -- Forwarded message --
>> From: Hari
>> Date: 8 January 2013 11:43
>> Subject: Fwd: Interest formulae
>
any views / comments folks ?
Also, are there other windows forum where I can ask this question ?
thanks in adv
regards
Subu
On Saturday, January 5, 2013 8:56:31 PM UTC+4, .. wrote:
>
>
> Dear Folks
>
> Could someone please suggest a good Ms Windows user group ?
>
> Why do I ask ? Yesterday
Hi Prashant,
*Advantages when using class modules :*
1. Class modules makes it possible to separate complicated source code
for advanced processes. This makes it easier for other to use the source
code without understanding how the process is performed.
2. Class modules makes the d
Thanks Divaker
Regards
Amol
On Tue, Jan 8, 2013 at 6:46 PM, Divaker Pandey wrote:
>
> PFA
>
>
> On Tue, Jan 8, 2013 at 1:40 PM, Amol J wrote:
>
>> Hi Experts,
>>
>> I need help
>>
>> I have multiple shapes in sheet so i want color only one shapes in that
>> perticular sheet. So I created a fun
Paul described wonderfully. Class Module are very Important part of VBA. By
using this you can create your own event or event driven procedure. This
comes in Advance programming.
You can run a program by clicking a command button or by changing the
worksheets or there are number of events which you
Hi Paul, Anything is fine..
Thanks...
On Tue, Jan 8, 2013 at 11:33 PM, Paul Schreiner wrote:
> Are you looking for a VBA solution?
> How do you want to use this? (what steps do you want to take to run it?)
>
>
> *Paul*
>
> -
> *“Do all the good you can,
>
Are you looking for a VBA solution?
How do you want to use this? (what steps do you want to take to run it?)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the
Here is a somewhat vague description/analogy.
It's not ENTIRELY accurate, but I think will get the idea across.
First, let's look at an "Object".
Objects can have properties and mothods associated with them.
Let's take, for example, the Range object.
A Range object can have a Value,
but it can al
Lalit
Thanks again for all your help I have it working well now.
On Mon, Jan 7, 2013 at 9:17 PM, Lalit Mohan Pandey wrote:
> Please check the data ranges you provided and it will not activate the
> sheet it will run for all sheets in the workbook.
>
> On Monday, 7 January 2013 23:43:51 UTC+5:
Sent from Samsung Mobile
Original message
Subject: significance of using classes in VBA
From: "Shinde, Hanumant"
To: "arsfan2...@yahoo.co.in"
CC:
Hi friends,
I am going through Classes in VBA. I am not sure why we should uses classes. I
don’t understand the significan
Hi, Thank you very much. This is simply superb. :-)
On 08/01/2013, Swapnil Palande wrote:
> Hi Mathan,
>
> Pls find attached excel for solution.
>
> Open the attached excel and press "Ctrl + q" to run macro.
>
> I have added extra 2 columns ("Pieces Remain" and "Total Length") for
> calculation
Dear Prince and Lalit Thanks for response.
what i wanted in a excel file:-
Student ID Class SubjectMarks(Mandatory)
123 V Maths
345 V Maths
123 V English
456
PFA
On Tue, Jan 8, 2013 at 1:40 PM, Amol J wrote:
> Hi Experts,
>
> I need help
>
> I have multiple shapes in sheet so i want color only one shapes in that
> perticular sheet. So I created a function which Change the color of
> provided set of shapes.
>
> I want know how to pass array of shapes
Hi Friends,
>
> I have a problem which needs to be solved with excel (if not possible pls
> let me know in which other way it's possible)
>
> *Here is the logic:*
>
>
> There is a production line to make iron rods. It is a long steel form
> into which steel get placed. Number of pieces per jo
@ Jeet Singh,
It's surprising, you took almost a day time to***edit **Ashish Koul*
Suggestion???
On 08-01-2013 2:13 PM, jeet singh wrote:
=SUMIFS(C2:C11,A2:A11,">="&F2,A2:A11,"<="&G2)-SUMIFS(B2:B11,A2:A11,">="&F2,A2:A11,"<="&G2)
REGARDS
JEET SINGH
On Mon, Jan 7, 2013 at 7:06 PM, Yahya M
=SUMIFS(C2:C11,A2:A11,">="&F2,A2:A11,"<="&G2)-SUMIFS(B2:B11,A2:A11,">="&F2,A2:A11,"<="&G2)
REGARDS
JEET SINGH
On Mon, Jan 7, 2013 at 7:06 PM, Yahya Muhammad wrote:
>
> Dear experts
>
> I have an excel file to track the bank transactions. It has a debit column
> for the withdrawals and credit co
Dear Friends,
I need your expert advice in a Formula, I will have to create a Smallest
formula to calculate employees leave balance. this formula would calculate
that how many leaves will carry forward
of an employee. Conditions are mention below.
If Employee joining date is before 1-Jan-12 and h
Hi Anmol,
you can pass multiple shapes as an array using my previos post's method.
Regards,
Lalit Mohan
On Tuesday, 8 January 2013 13:57:46 UTC+5:30, Lalit Mohan Pandey wrote:
>
> Hi Amol,
>
> *Sub test(ParamArray Arr() As Variant)*
> *
> *
> *'Code here*
> *
> *
> *End Sub*
>
> Regards,
> L
Hi Amol,
*Sub test(ParamArray Arr() As Variant)*
*
*
*'Code here*
*
*
*End Sub*
Regards,
Lalit Mohan
On Tuesday, 8 January 2013 13:40:56 UTC+5:30, Amol J wrote:
>
> Hi Experts,
>
> I need help
>
> I have multiple shapes in sheet so i want color only one shapes in that
> perticular sheet
Hi Experts,
I need help
I have multiple shapes in sheet so i want color only one shapes in that
perticular sheet. So I created a function which Change the color of
provided set of shapes.
I want know how to pass array of shapes to function.
Please help me to solve this problem
Thanks
Amol
--
Thanks excel learner.
On Tue, Jan 8, 2013 at 7:16 AM, Ms-Exl-Learner wrote:
> *Compatible, Faster & Shorter Length formula
>
> **=SUMPRODUCT((A2:A11>=F2)*(A2:A11<= G2),(-B2:B11)+(C2:C11))*
>
>
>
>
> On 07-01-2013 9:00 PM, Yahya Muhammad wrote:
>
>
> Thanks Ashish. Is there any way we can combi
23 matches
Mail list logo