Hi, I'm new in the VBA. I'm trying to fill values from two different columns (G50 down) and (H50 down) with some random numbers based on other cell values, but i'm receiving "runtime error 1004 application defined or object defined" when i use this syntax:
You can download my excel at http://anovabr.com/wp/wp-content/upl...do-efeito.xlsm
Please Login or Register to view this content.
Works fine on excel 2016, but no on excel 2010.
Thanks much!
In what way doesn't it work for you in Excel 2010?
I'm using that version and it seems to work perfectly well for me.
Do you get an error message or just not the results you expect?
If an error message, which one and on what line of code?
B
I tested in Excel 2003 and it works fine as well. There must be another issue other than version.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Also tested in Excel 2007! Still working there.
B.
Code works fine with my Office 2010 as well as Office 2016.
So it's probably not a problem in the code.
This error is notorious for it's cause can be a lot of things.
Did you try to step thru to code and see what line triggers the error?
Also Excel's internal admin is not waterproof and may get somewhat ambigeous.
You might create a new workbook and copy range C2:Q51 (incl. the objects and the macro).
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Wow! Thanks, guys, for the reply.
I'm receiving this message:
"Application-defined or object-defined error"
For this line
Private Sub CommandButton1_Click()
Range("G51:G2000").ClearContents
Range("H51:H2000").ClearContents
n1 = 49 + [H19]
--->> Range("G50:G" & n1).Formula = "=NormInv(Rand(), " & [H17] & "," & [H18] & ")" << ----
n2 = 49 + [K19]
Range("H50:H" & n2).Formula = "=NormInv(Rand(), " & [K17] & "," & [K18] & ")"
[I25] = "O Teste T (amostras independentes) chegou ao p valor de " & Round([D23], 2) _
& " com tamanho de efeito de " & Round([E23], 2) & "."
End Sub
imagem 1.PNG
When i change the order of syntax or change the code trying to fix it, the message appears to this command: "Range..."
I'm using office 2010.
Thanks again.
What's the value of n1 at that point?
That might result in an invalid range.
But then again, that should be a problem for 2016 to
Last edited by Tsjallie; 06-24-2017 at 04:48 PM.
Hi all,
I'm using, now, this code:
I figured out the problem:Please Login or Register to view this content.
VBA is configured to use DOT as decimal separator; my excel formulas is configured to use COMMA as separator.
See images below.
Here, i'm using dots. None of my formulas work, but VBA works fine
working.PNG
Here, i'm using comma as decimal separator. VBA doesnt work anymore:
working2.PNG
working3.PNG
If someone wants to try, i attached my excel file in this message.
https://www.dropbox.com/s/4lre2o6h12...g%29.xlsm?dl=0
Great find! That would never have crossed my mind (though weird things are crossing)
Thx for feeding back!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks