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 wrote:
>
> Hi,
> A quick way to reveal which cells have formulas:
> Ctrl+`
> That's Ctr
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 wrote:
> see attached file
>
>
> On Tue, Apr 14, 2009 at 8:05 PM, zekooo wrote:
>
>>
>> Dear All,
>>
>>
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 anythin
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, Marc
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 wro
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 wrote:
> Did anybody fix this workbook tha
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 wrote:
>
>
> Dear Members,
>
> A new tip of excel has been published o
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 wrote:
>
>
> Correction:
> QGAGGAAGGAGQ
> Palindromes Number Repeats Number
> QGAGGAAGGAGQ
Can you send a file instaed of rich text.
would be easy to understand
On Tue, Apr 14, 2009 at 9:05 PM, Kumar wrote:
>
> I Have an Excel Sheet which Contains the Following :
>
> DEPT Name Employee Name Emp CodeMonth Period From
> Period To Place
> FromPlace To
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 Josh
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 wrote:
>
> working with share file is much diffcult to fix this problem in excel
> becouse ev
I just uploaded an excel file in your group, how did that happen in
excel ? & how do i undo it.
Sorry i could not manage to upload it ,attach it here, maybe the
moderators can help ?
--~--~-~--~~~---~--~~
Correction:
QGAGGAAGGAGQ
Palindromes Number Repeats Number
QGAGGAAGGAGQ1 GA 3
GGAAGG 1 GG 2
GAAG1 AG 3
GAG 2 GAG 2
GG 2
Hi Sleek,
The file has been uploaded to files section. Please check there.
Best regards,
Ayush Jain
On Apr 14, 9:29 pm, Sleek wrote:
> I just uploaded an excel file in your group, how did that happen in
> excel ? & how do i undo it.
> Sorry i could not manage to upload it ,attach it here, mayb
working with share file is much diffcult to fix this problem in excel
becouse every user will seat in different different pcs and everytime
user have save the data to make the data sheet update my suguestion is
this please user msaccess to perform this task
thank
santosh bahuguna
On 4/11/09,
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
Offs
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 Che
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 so
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 un
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 wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same
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 wrote:
> On Tue, Apr 14, 2009 at 12:24 PM, Suryaprasad.bv
> wrote:
>
> > Prashant,
>
> > Can you post me a sample file so that i can help you
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 speci
On Tue, Apr 14, 2009 at 12:24 PM, Suryaprasad.bv
wrote:
> Prashant,
>
> Can you post me a sample file so that i can help you out
>
> Cheers
> Surya
>
>
>
> On Tue, Apr 14, 2009 at 12:16 PM, Prashant Pednekar > wrote:
>
>> Hi All
>>
>> here my doubt is
>> The Validation is not having constraint,
>
Prashant,
Can you post me a sample file so that i can help you out
Cheers
Surya
On Tue, Apr 14, 2009 at 12:16 PM, Prashant Pednekar
wrote:
> Hi All
>
> here my doubt is
> The Validation is not having constraint,
> i.e. afte entering one product and specification, if i am again changing
> the
25 matches
Mail list logo
