Hi Serghei,
Thanks for your help. It is working fine.
Meanwhile I also got the solution.
I have written a macro for my 1st query ie. for calculating % value
automatically
and for second query I am doing conditional formatting.
Following is the formula for conditional formatting.
=OR(AND(L5 =
Hi Harris,
Please find attached excel for solution to your problem. Press update button
to run macro.
If you have any query let me know.
Best regards,
Swapnil.
On Fri, Jul 31, 2009 at 10:53 AM, harris a harris...@gmail.com wrote:
Hello,
I am enclosing file example.xls. I need help in
Hello,
This is the formula you would use in your results cell:
=COUNTIFS(A1:A6,$B$8,A1:A6,$C$8)
Where A1:A6 is you range of 24,35,36,38,37,48,42 and $B$8 $C$8 are your
criteria parameters. You can have a number if nested criterias in the COUNTIFS
function.
Regards.
I am running Excel 2003. When I sign a document with a digital
signature, is there any way to easily see that the document is signed
without having to go to Options - Security - Digital Signatures? In
Word there is a red ribbon that's displayed at the bottom of the
screen. Also, is there a way
Hi Serghei,
Thanks, Macros are working properly.
Best regards,
Swapnil.
On Fri, Jul 31, 2009 at 2:33 PM, Serghei Ovanesov oserg...@hotmail.comwrote:
Hello Swapnil,
Find attached the same solution in Excel 2007. However you must insure you
have macro's security settings set changed to
hello
thank you very much for the solution. But is it possible to have the
formula in excel rather than VB. excel formula would be help to me in
replicating. thank you. regards. Harris
On Jul 31, 3:16 pm, Swapnil Palande swapnilp1...@gmail.com wrote:
Hi Harris,
Please find attached excel for
A couple of things.
I assume that you have both versions of Excel loaded and don't wish to
uninstall the older version...
When you say that when you open test.xlsm directly it opens as a regular 2007
excel
When you do this, is Excel already open and then you double-click the file from
an
Paul,
When I click the test.xlsm file it always opens as 2007 version, no
prior version of any excel is open at that time.
now I tried your suggested approaches:
1. Used C:\Program Files\Microsoft Office\Office12\EXCEL.EXE C:
\foldername\test.xlsm BUT this doesnt trigger to initiate my
I have a userform with two listboxes (listbox1 and listbox2). The
user can select values from one listbox1 and transfer them to lisbox2
via a command button.
Here is my problem: I need to transfer ALL the values in listbox2 to
a range on my spreadsheet when the user clicks a command button
hey Paul,
I tried your option #1 with this one in RUN: C:\Program Files
\Microsoft Office\office12\EXCEL.EXE C:\temp\Test.xlsm and somehow
this does not trigger to open my file.
It works if I keep C:\temp\Test.xlsm under RUN
should it be under STart in? my start in : C:\Documents and Settings
Hi,
I have also come across this problem. I have not found a way to search a sheet
that is not selected.
The work-around I use is as follows:
Application.ScreenUpdating = False
A = ActiveSheet.Name
Your code here, including the Sheet.Select line
Sheets(A).Select
Application.ScreenUpdating =
11 matches
Mail list logo
