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 =
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 Setting
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 (e.g
sorry to confuse you, but in option #1,
you have to change the path names to the ones for YOUR location:
Is Excel in:
C:\Program Files\Microsoft Office\Office12\EXCEL.EXE ??
and, is your file called:
C:\foldername\test.xlsm
I REALLY doubt that you have a folder called 'foldername'!
Also, keep in m
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
tes
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 exp
All,
I've scheduled a task to open my test.xlsm ( excel 2007 macro
enabled ) file everyday but when it opens automatically, it opens as a
2003 excel file and messes up few formulaes and charts which I have
created in 2007.
When I open test.xlsm directly it opens as a regular 2007 excel.
Any ide
Hi Harris,
It may be possible to do this using formula. But I don't know how to do it
using formula.
You have to just change the range in given macro according to your data.
Regards,
Swapnil.
On Fri, Jul 31, 2009 at 7:52 PM, harris a wrote:
>
> hello
>
> thank you very much for the solution.
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 wrote:
> Hi Harris,
>
> Please find attached excel for solution to your pr
Hi Serghei,
Thanks, Macros are working properly.
Best regards,
Swapnil.
On Fri, Jul 31, 2009 at 2:33 PM, Serghei Ovanesov wrote:
> Hello Swapnil,
>
>
> Find attached the same solution in Excel 2007. However you must insure you
> have macro's security settings set changed to enable all macros.
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
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.
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 wrote:
> Hello,
>
> I am enclosing file <>. I need help in populating the report
> table
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 = 0%,
H Frnds
Is there a way to create a formula that counts the amount of numbers out of
a serie of numbers when a certain criteria is set.
Example 24,35,36,38,37,48,42 set of numbers, what i need is a formula that
counts the amount of numbers when the criteria is set numbers between >30
<40 the r
15 matches
Mail list logo
