I have data in two columns - column A and column B. Values in column b can be either 0, 5 or 6. I want to iterate through all the cells in column B. If the value of a particular cell =0, then I want to add the value from the cell to the left of it to an array; if it is <>0, then I just want to go on to the next cell. Once I have finished the iteration, I want a Message Box to appear depending on if the array is empty or not. In the array = 0, then the message should be "No missing data"; if the array has data, then "Missing data for: " + the values stored within the array.
I've never really worked with arrays in VBA so I'm not too sure how to proceed.
This is how I've structured the code so far:
Any help with the array bits of the code would be most appreciated. I've put in the bits where I'm unsure how to proceed.
Please Login or Register to view this content.