Sorry, this is probably very simple but I can't figure out how to store an actual range as a variable rather than the value of the desired range. My code is:
sub test()
dim last_row as integer
dim searcher as range
dim finder 
    last_row = Cells(Rows.Count, 1).End(xlUp).Row
    Set searcher = sheets("Summary").Cells(last_row, 1)
    Set finder = Range("A1:searcher").Find("AB Total", Cells(1, 1), xlValues, xlWhole, xlByRows, xlNext)
    x = finder.Offset(0, 4).Value
    y = finder.Offset(0, 7).Value
    cells(2,2).value = (x/y)
I would like my searcher variable to store the range("A80"), but instead it is storing the string insde "A80". This gives me a "Range of Object_Global Failed" error. How do I resolve this? Thanks!