Range name from range in a cell

[mrdmw]

Hi

I have a few cells in a column with different ranges in them. I would like the vba code to loop through this column, read the range in the given cell (eg cell B2 contains "Tables!$B$2:$D$7") and then name the range ("Tables!$B$2:$D$7") what is given in the column next to it (eg A2 contains "Table 1").

And then loop through the column.

Thanks