The values wont come out right with that setup. I was able to adjust it to get Xbar and Rbar coming out right but the control limits think there are 10 columns of data. basically I am just trying to set it up where Column A would just be labeled samples in A1 then go down the column counting from 1-30. Then row A(B1, C1,D1,E1,F1,G1,H1,I1,K1) would say Observation 1-10. This creates my data entry area for the user. So they know where to place their data. Then I just want to have my subroutine that I posted ignore column A and row 1. Problem is that it believes since I have a label or header to then count that row or column as if it has a value. So even when I only put 4 rows it acts like I have 30 and same with columns going up to 10.