Dave, You can also select cont+G, click on special tab and again click on
formula's tab, all cells whic contain formula's will get highlighted, you
can now select the fill color option and colour the cells with your
favourite colour.
Regards,
Shay
On Tue, Apr 14, 2009 at 10:24 AM, Dave Bonallack
Hi All,
This may help. Chang the code as you want.
Sub ChangeformulaColor()
If Application.IsText(ActiveCell) = True Then
MsgBox (Text)
Else
If ActiveCell = Then
MsgBox (Blank)
Else
End If
If ActiveCell.HasFormula = True Then
ActiveCell.Select
With Selection.Font
Hi All,
Can anyone help me in creating a macro. example for filter for
employees like Kishore and wht ever value appears in column B copy and paste
it in a fresh excel like in sheet 1 and in sheet 2 of the same workbook paste
another employee's data in sheet 2 etc like this.
HI !!
Well click on F5 - special - go to special - Formula - Click ok - And than
chose your colour.
Hope this may suffice
On Mon, Apr 13, 2009 at 11:45 PM, Ned ned...@yahoo.com wrote:
could anyone tell me how to color code an excel cell if a cell has a
formula. I have a long
Hi Harpreet,
I have recently joined this group its my pleasure to learn such wonderful
things from you guys.
I really thank you all.I am starting to learn Macro's kindly suggest me the
right path tutorails which can really guide me additional to your personal
help.
Regards,
Harish
Dear Members,
A new tip of excel has been published on the blog . The title of
the tip is The Camera Tool in Excel.
Please visit the below link for this tip.
http://exceldailytip.blogspot.com/2009/04/tip-49-camera-tool-in-excel.html
To see the archive of these Excel Tips, Go to:
Hi Shay,
Thanks for that. Always learning.
Regards - Dave.
Date: Tue, 14 Apr 2009 10:30:53 +0530
Subject: $$Excel-Macros$$ Re: color code excel cell if a cell has a formula
From: shahinarafi...@gmail.com
To: excel-macros@googlegroups.com
Dave, You can also select cont+G, click on
There is another way to do this using Named Ranges and the Indirect
() Function
Let me know if you are interested
On Apr 14, 2:03 pm, Prashant Pednekar prashant...@gmail.com wrote:
On Tue, Apr 14, 2009 at 12:24 PM, Suryaprasad.bv
suryaprasad...@gmail.comwrote:
Prashant,
Can you post me
Hi Lavprasad Kori
Pls find the attached file with the solution u want.
Regards,
Deepak Rawat
On Mon, Apr 13, 2009 at 4:54 AM, Lavprasad Kori lavprasa...@gmail.comwrote:
Dear Friends,
I am downloading the employee data from our portal. In, there is employee
name Emp. ID both
Hi Prashant,
For Validation, you have to choose both of the items i.e. Base Data and it's
validation, in order to change both the values.
i.e. you have choosen Product 1 and then Specification 6. Now, if you have
choosedn Product 2, the next item (Specification 6) will not change
automatically
Dear all,
I am looking to detect palindromes (sentence or number or other
sequence of units that can be read the same way in either direction)
and repeats (sequences of letters or numbers
which are repeating atleast twice within a string) in some strings
containing between 20-5000 letters. Has
I Have an Excel Sheet which Contains the Following :
DEPT Name Employee Name Emp CodeMonth Period From Period
To Place
FromPlace ToJourney FareD.A Conveyance- Exp Misc. Exp
Mum ABC 18647 JAN 21/01/2009 02/02/2009 Mumbai
Dear All,
In the validation column try using a combination of these formulaes:
=OFFSET(AE1,MATCH(B8,AE2:AE65536,0),1,COUNTIF(AE2:AE65536,B8),1)
Wherein AE2 : AE65536 should contain thelist of products chosen.and given
the specifications alongside these in the next column. As a result of the
Correction:
QGAGGAAGGAGQ
Palindromes Number Repeats Number
QGAGGAAGGAGQ1 GA 3
GGAAGG 1 GG 2
GAAG1 AG 3
GAG 2 GAG 2
GG 2
Good idea,
but we can come out of that situation.
Harish, Just put a line in the macro before msgbox:
activeworbook.save
hope that solves the issue
On Tue, Apr 14, 2009 at 8:55 PM, santosh bahuguna santoshbahug...@gmail.com
wrote:
working with share file is much diffcult to fix this
Hello,
This is Jayesh Joshi , I want to learn from the start the basic
fumctions of excel and also MACRO's as it is useful in my job . My
basic requirment is PIVOT Tables and learning Macros Could you guys
please help me out of this.Waiting for your prompt reply.
Thanks and Regards
Jayesh
Can you send a file instaed of rich text.
would be easy to understand
On Tue, Apr 14, 2009 at 9:05 PM, Kumar phanikumar...@gmail.com wrote:
I Have an Excel Sheet which Contains the Following :
DEPT Name Employee Name Emp CodeMonth Period From
Period To Place
From
Hello
I'm trying to write a small excel vba script that returns TRUE if in
a selected area of cells there are any merged cells.
Sounds simple, but I haven't found the solutions yet... :-(
Is there a poperty that I can check for merged cells??? Or any other
trick that helps
Any hint is
check the below link
http://funwithexcel.blogspot.com/2009/04/macro-to-write-mathematical-palindromes.html
You might tweak or extend from there.
On 4/14/09, Luciano Paulino da Silva lucianopaulinosi...@gmail.com wrote:
Correction:
QGAGGAAGGAGQ
Palindromes Number Repeats
Hi Ayush,
I like the tool but how different is this from copy / paste. I really don't
see any difference. Can you explain some real time scenarios where this is
used more than copy / paste.
Thanks,
Srinivas.
On 4/13/09, Ayush jainayus...@gmail.com wrote:
Dear Members,
A new tip of excel has
Hey Phillip,
Nice to know that you are at least talking about it. I am very much
surprised that nobody has ever given any suggestion about my problems.
Hope sum one finds solutions soon
Thanks
Hems
On Wed, Apr 15, 2009 at 12:00 AM, Phillip Swanepoel pswa...@gmail.comwrote:
Did anybody fix
Hi Hamster,
I don't know your requirement. But with design perspective writing a code
around save is not recommended because you might hit save button or Ctrl + S
many a times unknowingly while working with excel. Just check it out.
have fun,
ddadmin.
On Mon, Apr 13, 2009 at 10:11 AM, Hamster
Did anybody fix this workbook that was send with this email?
workbook in question is called CallLogging_newA.xls and it has been send on
28 March 2009 08:11 PM.
Thanx
Pswanie
- Original Message -
From: Ashish Jain
To: excel-macros@googlegroups.com
Sent: Saturday,
Hi ajxecc,
Try this code:
Sub mergedetect()
Dim c As Range
For Each c In Range(A1:A10)
If c.MergeCells = True Then MsgBox c.Address is merged with another cell.
Next c
End Sub
Change the Range ref to suit your needs.
You can change the code after the Then keyword, to do anything you
thanks Harmeet
but what i need to sum the data (overtime) (absent) as hours not value ,
is there any way to sum hours
best regards
zohair
On Tue, Apr 14, 2009 at 9:02 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
see attached file
On Tue, Apr 14, 2009 at 8:05 PM, zekooo
Here is a very easy method to resolve this issue rather than using the VBA
code.
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
Hope this helps.
On 4/13/09, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
A quick way to reveal which cells have
26 matches
Mail list logo