PFA
Cheersss!
Rgds//Vabz
On Monday, September 10, 2012 10:26:32 AM UTC+5:30, amar takale wrote:
>
> Hi All Experts
> Pls suggestion for required formula
>
> On Fri, Sep 7, 2012 at 7:18 PM, amar takale
> > wrote:
>
>>
>> --
>> Join official facebook page of this forum @
>> https://www.fac
Sorry, I don't really understand your point.
I realise VSTO will be the way to go, I don't really have many issues with
that. My point is that I pay MS a lot of money, as do my clients. Solutions
have been built in good faith that MS will maintain backwards
compatibility, and they are effectiv
Dear Sujit,
See attached sheet with EXCEL and VBA Solution both.
On Sat, Sep 8, 2012 at 3:27 PM, wrote:
> Dear Excel Gurus,
>
> Greetings!!!
>
> Can you pls tell me know how to convert numbers to text ? Eg: '23' to
> 'Twenty Three'.
>
> I tried doing it with '=spellnumber' but its not working i
To Harshad:
In Excel 2010 you can use the DisplayFormat object, which indicates the
range (cell) format properties as actually displayed, including conditional
format and table style effects.
Bob Phillips and Chip Pearson have both published functinos that can
evaluate the color of a cell acc
Hi
Do you want comm. to be shown in respective applicable col. only or pl
check soln i have given.
Rgds//Vabz
On Monday, September 10, 2012 1:20:05 AM UTC+5:30, prkhan56 wrote:
>
> Hello All,
>
> We have a group of employees having various Grades and Position.
>
> 1) A fixed target of sale
Hi All Experts
Pls suggestion for required formula
On Fri, Sep 7, 2012 at 7:18 PM, amar takale wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread tit
Dear Rajan
Thanks for your idea, If I've have many row (data) ,So it still work ?
Attapan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: Sunday, September 09, 2012 1:18 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$
I don't know the book, but here it is. Rajan had a small typo in the
author's name, perhaps that was the difficulty:
http://www.amazon.com/Microsoft-Functions-Formulas-Edition-Computer/dp/19364
20015/ref=pd_bxgy_b_text_y/185-8930763-6171505
Or the downloadable Kindle Edition:
http://www.amazon.c
I missed that part but did ask for clarification. This code simply responded to
the other code offered.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: David Grugeon
Sent: Sunday, September 09, 2012 2:14 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Ex
Hello All,
We have a group of employees having various Grades and Position.
1) A fixed target of sales to be achieved every month as shown in Col
D (Target).
2) Each level has different Target Criteria as shown in Col C5.
3) Commission Criteria is shown in F3:K3
4) Achievem
See attached
On 10 September 2012 05:02, Dhananjay Pinjan wrote:
> Dear Experts,
>
> I need a solution as per my query in attached file.
>
> Pl. revert in case of any clarification or any confusion.
>
> Regards,
> Dhananjay
>
> --
> Join official facebook page of this forum @
> https://www.faceb
Hi Don
The question said the colours are set by conditional formatting. This does
not affect interior.ColorIndex. AFAIK the only way to do it is to apply
the same test for the condition as you used in the conditional formatting.
On 10 September 2012 02:18, dguillett1 wrote:
> Or this to l
Dear Experts,
I need a solution as per my query in attached file.
Pl. revert in case of any clarification or any confusion.
Regards,
Dhananjay
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
Or this to look in column A for the colors in column C
Sub sumcolormatchSAS()
Dim c As Range
Dim i As Long
Dim csum As Long
For Each c In Range("c2:c3")
c.Offset(, 1) = 0
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Row
If Cells(i, 1).Interior.ColorIndex = c.Interior.ColorIndex Then _
c.Offset
Prince.. what if cells are colored by Conditional formatting ??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: 09 September 2012 8:45
To: excel-macros@googlegroups.com
Subject: $$E
Hi Vijay,
I hope you got ur answer as David explained. Those are the best way to
learn new things of VBA.
regards
prince
On Saturday, September 8, 2012 3:17:44 PM UTC+5:30, Vijay Aggarwal wrote:
>
> Hello Excel VBA Gurus!!!
>
> My name is Vijay and currently I am working in MIS Team of a MNC in
Nice formula Don
regards
prince
On Friday, August 31, 2012 6:05:54 PM UTC+5:30, Kuldeep Singh wrote:
>
>
> Hi Experts,
>
> I want to required Revenue started from Date.
>
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukri...@gmail.com || www.naukri.com
> *Please* *Consid
Hi Sujit,
Please just copy and paste the following code and call this function on
worksheet As * SpellNumber(Number) *
*
*
*
*
*
Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2)
Hi Harshad,
Please see the attachment hope this will help you.
regards
prince
On Sunday, September 9, 2012 12:19:35 PM UTC+5:30, harshad shukla wrote:
>
> dear all,
> I had a query where in i had to sum the values of cell based on cell
> colour.that is to add all
> numbers of a row whose cell
---**
*From:* Sara Lee [mailto:lee.sar...@gmail.com]
*Sent:* 09 September 2012 7:41
*To:* Rajan_Verma
*Subject:* Re: macro for pivot
** **
once i copy and paste into a new module, how to run this macro?
how do i link this code to the spreadsheet i am working on?
Can you please give exact
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Sara Lee [mailto:lee.sar...@gmail.com]
Sent: 09 September 2012 7:41
To: Rajan_Verma
Subject: Re: macro for pivot
once i copy and paste into a new module, how to run this macro?
how do i link this code to the spreadsheet i am
At some point, developing for Office requires access to Visual Studio full
package or alternative equivalent tools. I don't think it's about killing
VBA for VSTO, I would see this more like setting or defining a border
between Office custom solution and Office professional solution. It makes
se
Your excel version is _)___
How did the cells become colored__
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: harshad shukla
Sent: Sunday, September 09, 2012 1:49 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
dear all,
Since it is not anything to do with Excel or Excel macros I hope the
user will find this link to a free website useful and i am not
offending anyone by providing it.
http://www.dynamics-nav-training.com/
It came up on the first page of a Google search.
On 9 September 2012 17:17, Rajan_Verma wro
Can you explain , what Navision notes ,
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cute Awesome
Sent: 08 September 2012 11:56
To: excel-macros@googlegroups.com"
Subject: $$Excel-Macros$$ please
Right approach said by David.
You can also use subtotal in first row and can filter colored Row only, see
the attached file.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of David Grugeon
Sent:
26 matches
Mail list logo
