I am to delcare a new variable new_obs and then set the variable to integer.
And below the comments at the top of the sub procedure, enter the following statements:
This variable will store the observation number of the quality control sample.
After I do that I have to set the value of the new_obs variable equil to one
plus the value of cell A3 in the QC Data worksheet.
I am given a hint: Use an object reference that includes the object hierarchy from sheets collection to the range object.
So this is what I have already done
This variable will store the observation number of the quality control sample.
Public Sub new_obs()
Dim num1 As Integer =1, QC Data A3
I am more confussed now then I was before, once I added them all came out red with errors.
Please help me understand how I am to write this please....
Susie
And below the comments at the top of the sub procedure, enter the following statements:
This variable will store the observation number of the quality control sample.
After I do that I have to set the value of the new_obs variable equil to one
plus the value of cell A3 in the QC Data worksheet.
I am given a hint: Use an object reference that includes the object hierarchy from sheets collection to the range object.
So this is what I have already done
This variable will store the observation number of the quality control sample.
Public Sub new_obs()
Dim num1 As Integer =1, QC Data A3
I am more confussed now then I was before, once I added them all came out red with errors.
Please help me understand how I am to write this please....
Susie