如何将单元格地址存储到VBA中的变量以不断更改范围限制

I am trying to write a macro that searches a whole sheet for a value and then stores the values and locations of ALL hits for that value throughout the sheet. I will do something with the locations and values later, but I need to get this bit working first.I am trying to write a macro that searches a wh