Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I got weird problem and need help:(

I worte VBA as following;

(Sub xformula()

dim i,k, q as double

q = Worksheets("input").Range("e12").Value

For i = 1 To q

k = Worksheets("input").Cells(14 + i, 6).Value

Cells(11 + i, 7).Value = 1 + (MAx(Cells(11 + i, 5).Value, 0.2) - 1) / Sqrt(k)

Next i

End Sub)

But the MAX and Sqrt functions do not work here. the system gave me error,

please help! Thanks!

MAX and SQRT are worksheet functions, not VBA functions. Some worksheet

functions can be used in your VBA code, if you specify them as

Application.WorksheetFunction.FUNCTION, where FUNCTION is one of the available

worksheet functions. With this change, your code looks like this:

Sub xformula()

Dim i As Double, k As Double, q As Double

q = Worksheets("input").Range("e12").Value

For i = 1 To q

k = Worksheets("input").Cells(14 + i, 6).Value

Cells(11 + i, 7).Value = 1 + (Application.WorksheetFunction.Max(Cells(11

+ i, 5).Value, 0.2) - 1) / Application.WorksheetFunction.Sqrt(k)

Next i

End Sub

I haven't tested this, but it compiles correctly. Also, SQRT() applied to to

negative number will generate an error.

I tried, the Max function did work. but it seems the SQRT doesn't belong to

worksheetfunction and it didn't work. Are there anyway to use SQRT function?

You can use the POWER function, which does belong to worksheetfunction, as

follows:

Application.WorksheetFunction.Power(k, 0.5)

This returns the square root of k.

Try k = val(Worksheets("input").Cells(14 + i, 6).Value)

I tried. but it gave me same error :(

The vba equivalent of the workshet function SQRT is SQR so

......./Sqr(k)

might work.

Didn't find what you were looking for?
Find more on Why math functions do not work?
Or get search suggestion and latest updates.

Related Topics:

- Math function to determine if a number is an int
- user-designed Excel math functions
- Why does Java not allow default function arguments ?
- please help - why this is not work (sub string in string)
- problem: I've done this in ACCESS, but not in EXCEL
- Math statement process
- Math.pow()
- New to JAVA and Frustrated with the math
- User Defined Function didn't work
- How does the Worksheets function work?
- Wait function and Invisible function
- How to make VB6 function work in VBA
- Wait function and Invisible function
- How to make VB6 function work in VBA
- runge kutta method with a specific math problem
- Why it doesn't work? (use o Vector)
- Why Isn't this working?
- Why isn't this code working?
- User defined functions not recognized
- Why ORM Tools are not Recommended?
- dos code page
- Why are we not using Java EE 5?
- Why not compile Java for Windows?
- steps 2 connect 2 database 4 doing J2EE project
- ANTI-DoS sys