I have a loop that reads through worksheets in a workbook and creates equations in specific cells to parse data. The problem is that one of my equations does a lookup in a named range in another sheet and I need to be able to place a variable in the equation so that it will paste the correct...