Type: Posts; User: 3com
Search took 0.01 seconds.
anyway you can do the trick, via Conditional Formatting.
as Sid said.....
Find function store return value into variant/object variable.
To pass return value to these type of variable you should use (Set). IE: Set Var=selection.Find(.......)
Try as follow:
Function N(ByVal x As Double) As Double
N = Application.WorksheetFunction.NormSDist(x)
Function Delta(ByVal S0 As Double, K As Double, r As Double, q As Double, Sigma As Double, T...
Sorry my fault, I mean csv instead of cvs.
About csv files : http://en.wikipedia.org/wiki/Comma-separated_values
Import or export text (.txt or .csv) files:...
Your app can work with csv comma delimited files?
I guess you need a third element in the equation, and this file could fulfill this function.
Let's see if I understand you correctly.
You for whatever reason changed the function of some attributes, involved in the calculation of the OVR.
Now you want to adapt the code, in order to achieve...
Just adding something..
Sub CreateAccessDatabase(strDBPath As String)
Dim catNewDB As ADOX.Catalog
Set catNewDB = New ADOX.Catalog
Well, glad you got resolved. You are welcome. :)
Localize <Sub HandleOldFormulas> procedure and replace it, for code below....
Sub HandleOldFormulas(ByVal ncol As Integer)
'manage orange + Red Cells
Select Case ncol
Get to know Excel 2007: Enter formulas
Assure if the variable NameFund , it's taking correct value, do this one...
Check Debug output.
If not correct, then try..
NameFund is a variable.
Variant storing a string value, instead of string variable.
You do not miss something here?, for example the file extension, such as (.xls) or something like that.
In fact, they are complementary; since....
Perhaps, but I had interrupted your intervention in this thread, my apologies for that.
Well, that's good news.
Anyway if you think you already solved your problem, please come back and mark the thread as resolved.
If not, let me introduce a new generation calculator, much fastest and...
Well, forget sheet called "ColumnsID".
Another thing I miss..
In my "columnsID" sheet, all the formulas point to my "Calculations" sheet. You has to change, make point to your main sheet. Example:
I'll ask you some things that are perhaps obvious, but I need to be sure.
Do you added Sheet called "columnsID", to your book?
As for LS, you must select the pos2 in column(Y), and then select...
Sorry I miss tell you about...
Notice there are a new sheet called <columnsID>, you has to add that sheet to your book.
Right click over sheet "columnsID">Move/Copy>select your book>Select if you...
Sorry I missed this ones..
<SPC> is a reserved word for VBA. More info: http://msdn.microsoft.com/en-us/library/office/gg264453.aspx
this line of code FOOLPROOF THE SYSTEM, avoiding cpu overload.
If Abs(Cells(R, ATTR_MOD).Value) > 100 Then Exit Sub
This fórmula prevent values, less than 1 and greater than 99 .
Well, I can give you the fish, but I'm sure you prefer to learn how to fish it.
please go to the code window, and add this piece of code at the very end.
I sure vbfbryce can help'u in this issue better than me, because english version as you.
I mean using Quick Access Toolbar >more commands>Macros.
After that, localize DoMath macro, and add it to...
Well, I think, I get the error.
Goto this procedure, and add this line at the end: doMathRunning = False
Or replace the whole procedure by this one:
doMathRunning = True
Yeah, because it work for me. Change colors ans make calculations.
Anyway I will make best test later.
Sub doMath(), as you suggested above.
I keep the worksheet_change event code, because thus, you are able to make calculation for each one. And with Sub DoMath, you do the calcularion for everybody.
Adding related info..
Putting a database on a server is asking for trouble if it also has the forms,
queries, reports, modules and macros. These objects corrupt easily over a slow
Perhaps you will go fastes.
I think nO_OnE might be right about this.
I can not tell the difference, because the database I used, it has only 22 rows. Anyway, you try it.
1 - You goto Visaul basic, add this line of code in...
Throughout this project, I considered several different approaches to the issue, finally, I decided to leave the details to the last minute, but some things I've overlooked things like...
This file, do ,the trick; at least for me.
The tuto, for learn how you work with personal macro book, if you want to.
Dim str As String
Dim myString, arrStr
myText = "ABC Auto Repair"
myString = Split(myText)
For i = 0 To UBound(myString)
If myString(i) <>...
Well,following the Bryce's suggestion, copy and paste this piece of code, into your "main sheet" code module.
Dim lrow As Integer
Dim wb As...
Please, if you solved the issue, come back and mark thread as resolved.
Click Here to Expand Forum to Full Width