L
Hello,
Problem 1:
I have a macro to make a repetitive GageRR (for different measurements, normally more than 200).
to do this I'm manually pasting all data into mainitab and split using Data/Split Worksheet.
after that I just Run my macro and make the GageRR graphs, but some cases I have no data into some columns (that is the limits columns and some times has no Minimum or maximum), so is EMPTY cell or column
in that cases, I'm getting the next error:
------------------------------------------------------
LET K1 = C7[1]
S
* ERROR * Empty column, undefined or illegal stored constant at S
* ERROR * Completion of computation impossible.
--------------------------------------------------------
How I can mange this error before happen? how Can I verify that that cell is empty before?
Problem 2:
If all data is in place, I'm getting the GageRR result into graphs, but the is no a numerical sign of the results, just BARS. I been trying to put that labels directly into graphs, but no results, how can I get data from "Session" screen? I can see than the data is into that window, or any other way to get the GageRR result as text?

Problem 1:
I have a macro to make a repetitive GageRR (for different measurements, normally more than 200).
to do this I'm manually pasting all data into mainitab and split using Data/Split Worksheet.
after that I just Run my macro and make the GageRR graphs, but some cases I have no data into some columns (that is the limits columns and some times has no Minimum or maximum), so is EMPTY cell or column
in that cases, I'm getting the next error:
------------------------------------------------------
LET K1 = C7[1]
S
* ERROR * Empty column, undefined or illegal stored constant at S
* ERROR * Completion of computation impossible.
--------------------------------------------------------
How I can mange this error before happen? how Can I verify that that cell is empty before?
Problem 2:
If all data is in place, I'm getting the GageRR result into graphs, but the is no a numerical sign of the results, just BARS. I been trying to put that labels directly into graphs, but no results, how can I get data from "Session" screen? I can see than the data is into that window, or any other way to get the GageRR result as text?

Last edited by a moderator: