I have an array of data, 40 columns wide and 50 rows high, each cell having a number. I am starting to learn some VBA, and I wrote a few lines of code that will tell me if a specific number resides in the data. (Using For Col and For Row and then testing each row, col value against the input cell). How can you have the worksheet indicate the cell reference or row/column location of the number that has been found? I would like to have the location information entered in a cell(s) on the worksheet that contains the data. I also would ideally like to be able to determine if there are multiple occurrences of a number - maybe that should be a separate post. Thanks in advance, SJK.