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:
If .Cells(.Range("custom_name").Row + i, .Range("custom_name").Column) > Date then
do something here
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.