Hi Friends,
I have a query regarding counting of Colored cells. I want to know, is it
possible to count the no. of cells filled with a particular color with the
help of a formula. If yes then please guide me and help me in resolving
this.
Attached is a file which has an example, how I want to cou
Hi Friends,
Can any one help me on how to prepare control charts in Excel.
if possible send me some tutorials / information on the same...
Look forward to your co-operations
Regards,
Chandu
--~--~-~--~~~---~--~~
-
Hi Ravi,
Thanks, It worked :)
Regards
Prashanth
On Mon, Sep 14, 2009 at 8:13 PM, Ravi Kumar Vandavasi <
friendswrite...@gmail.com> wrote:
>
> Dear Prashanth,
>
> Append your formula like this. This should help.
>
> =IF(OR(D16=Summary!$C$3,C16="AAA", C16="BBB", C16="CCC"),"High",IF
> (D16
> Reg
Hi Pooja
Not possible in 2003 usinf formulas. Have to use VBA.
And if the cells are colored as a result of conditional formatting, it's even
trickier.
Regards - Dave.
Date: Tue, 15 Sep 2009 11:15:43 +0530
Subject: $$Excel-Macros$$ Count of Colored Cells
From: vatspoojav...@gmail.com
To: excel-ma
Hi Pooja,
Please find attached the file as per your requirement.
Please let me know if you have any questions.
Thanks & Regards,
Ankit Mehra
On Tue, Sep 15, 2009 at 11:15 AM, Pooja Sharma wrote:
> Hi Friends,
>
> I have a query regarding counting of Colored cells. I want to know, is it
> possi
Hi Pooja,
Its possible in MS Excel 2007. There u can filter by colour & count the
coloured cells.
Regards,
Lavprasad
On Tue, Sep 15, 2009 at 11:15 AM, Pooja Sharma wrote:
> Hi Friends,
>
> I have a query regarding counting of Colored cells. I want to know, is it
> possible to count the no. of
Pooja,
Here is a couple of websites that accomplish this with a user defined
function (UDF).
http://www.exceltip.com/st/Count_by_color_using_VBA_in_Microsoft_Excel/518.html
http://www.ozgrid.com/Excel/count-sum-cell-color.htm
Norman
On Tue, Sep 15, 2009 at 1:45 AM, Pooja Sharma wrote:
> Hi Fri
*See attached file**found very nice function in vba...*
*hope this helps*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Tue, Sep 15, 2009 at 1:55 PM, Dave Bonallack
wrote:
> Hi Pooja
> Not possible in 2003 usinf formulas. Have to use VBA.
> And if the cells are
Paul,
That worked great. Thanks!
Doug
Paul Schreiner wrote:
> The problem is that you're not telling
> VBA to use the VALUE of the variables,
> you're telling it to use the CHARACTERS
> in the NAME...
>
> what you need to do is "BUILD" the range like this:
>
>
>
> Range("C10:" & rCLR & ", D10:"
Hi Manoj,
Let me know if this answers your query.
Thanks
Prashanth
On Fri, Sep 11, 2009 at 7:28 PM, Manoj Kukrej wrote:
> hi,
>
>
>
> Pls find the attached sheet
>
> I want to put suffix/ prefix in the require cell
>
>
>
> Regards
>
>
>
> Manoj
>
> --
> This e-mail
Hello Excel guru's,
I want data in the main sheet into the format provided in sheets
510,511 and 512 besides the main sheet,I have been using autofilter
option,by filtering period column and wages column and creating new sheets,
then using vlookup formula to pull the data into my reports
I
Thanks Ashish
On Sep 14, 9:09 am, Ashish Jain <26may.1...@gmail.com> wrote:
> > Hi Mohit,
>
> > Please visit -
> >http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpo...
> > or check the VBA Code in attached file.
>
> >
Hi Robert
Please visit -
http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html
for full code and usage.
or use the code below
'Check that a slide exits, if it doesn't add 1 slide. Else use
the last slide for the paste operation
If ppApp.ActivePresentation.Slides
hi
i need a code which will automatically create a backup of my file at the
location i specify to it
thanks
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and
*This would help..*
ActiveWorkbook.SaveAs "c:\Backup_ManageAPP.xls"
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Tue, Sep 15, 2009 at 9:37 PM, ashish koul wrote:
> hi
>
>
> i need a code which will automatically create a backup of my file at the
> location i speci
First of all, Excel already has an AutoRecover feature
that saves the file every X minutes to a separate location...
but I don't like it either.
What do you mean by "automatically"?
for instance, I have a "save event" that
does a "SaveCopyAs"
like:
Option Explicit
Private Sub Workbook_BeforeS
Hi,
Hope it helps - http://www.wikihow.com/Create-a-Control-Chart
--
Thanks & Regards
Ashish Jain
Ph. No. - 0x25402CF2B
http://www.excelitems.com
* Excel,VBA,VSTO Trainer*
http://www.openexcel.com
* (Developer of Open
Hello All!
How are you? I hope fine!
I need your help, please. I'm writing a formula into a cell by a VBA
Code:
ActiveCell.Value = " = COUNTBLANK(" & CStr(RefEdit1.Value) & ")"
So, when I run this code, that cell returns "#NAME".
I just open the cell value to edit (but I edit anything) and say
Ashish Jain
F8
'billAddin'!PasteSpecialValue
I tried this and the button did not light up and enter did not run
the macro. Does it matter if the addin is installed?
Thanks,
Bill
On Sep 13, 6:46 pm, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Sneddon,
>
> This is true that add-in macros do
I'd bet that it's the space in " = Countblank
What *I* would do is:
run your code.
Record a macro
edit the cell and fix the formula
stop recording
look at the recorded macro.
It will show you what you need to use!
Paul
From: PauloBR
To: MS EXCEL AND VBA MAC
Hi Chechu & all of the group members
Thanks for your help..
I am really very new for this all macros and excel..
That would be great if you could help me to understand how to use this code.
--Bunty
On Mon, Sep 14, 2009 at 3:23 PM, Chechu wrote:
>
> Hi Bunty,
>
> Take a look to the followi
Dear Jitiesh,
I have done the same using simple pivot report , then using show report
filter pages option of pivot . It is very easy then formulas
Regards,
Prashant
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Jitheesh Vazhapully
Sent: Tu
22 matches
Mail list logo