I have been asked to figure out what cells in a column of cells total a specific number. There is no columns where I can key on to select only the column of numbers is relevant to what is needed. ex... in column H5 - H63 would have H4, H25, H40 and H57 cells add up to 401.98. I could put 401.98 in a cell that a formula would reference.

I am hoping someone in this forum has ( or can tell me how) a VBA routine that I can use to accomplish this.