Results for "custom function"
2 results for this search
I guess u can specify which folder to load files from at startup via the:
Advanced>General section of the Options dialog.
Also, any files stored here...
C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART
...will also be opened at startup.
My mistake
Now I saved as an XLAM file.
Does the file need to be opened to use the function in other files?
Hi,
The only way to do this is to save your file as XLAM, or please tell why you can't achieve this.
Hello everyone!
I wrote a custom function and I want it to work on any Excel file that I open.
How can this be done?
From an inquiry so far I understood that you can save as an XLMA file only that I could not
Thanks to the respondents
Hello,
thank you very much for your attention
Regards,
Ferdinan
Hello,
Realy they are the same.
Use the one that seems the easiest to program.
I'm going to try both methods and see which is the most efficient?
Thank you very much for your help.
Regards,
Ferdinan
Hello,
I have a file in which I have many functions and the file goes a little slow.
Which of these methods is the most efficient, so that it goes faster?
Regards,
Ferdinan
Hello,
The best for you is to create a Name with this Formula
Select the Cells "E2" and copy the Formula (Select it in the Formula Bar)
In the ribbon Open the Name Manager
Add a new name (By exemple SUBSTFRM) and in the ReferTo area put the Formula
Send Ok
Now you can use "= SUBSTFRM" instead of the original function.
Then in VBA you can write :
Range("E2:E10000").Formula = "=SUBSTFRM"
That's enough !
See the exemple...
Good afternoon,
Please, can you help me with this problem?
In the attachment, in column E I use a search function (= INDEX (Sheet2! $ E $ 2: $ E $ 32; MAX (INDEX ((Sheet2! $ A $ 2: $ A $ 32 = C2) * (Sheet2! $ D $ 2: $ D $ 32 = D2) * ROW (Sheet2! $ D $ 2: $ D $ 32) -FILA (Sheet2! $ D $ 1);))).
I would like to load this function in that column E with a macro.
How should the programming of the macro be?
Greetings,
Ferdinan