More efficient code using "with class" and .Cells, .Range, etc.? Excel, VBA

I'm trying to find more efficient methods for iterating through multiple row values in multiple workbooks. I think this is best illustrated through some code:

with data
  If .Cells(.Range("custom_name").Row + i, .Range("custom_name").Column) > Date then
    do something here
  end if
end with

Select allOpen in new window

Basically...I'm looking for a way to be able to start my "with" statement with data.Range and then back track into .Cells

...or find a different way to call a specific cell without the above .Cells(.Range1.Row, .Range2.Row) syntax, which is currently making my code extremely dense.