I have a Loop that goes through a set of data in range A1:B20. It's a
"Do While" loop that loops while the cells in column A have a specific
value. Cell B1 is always Blank and I want to assign this variable the
cells address. Example: Var x = ("B1"). Then at the end of the loop
I want the active cell to be the cell reference in Var x. Any idea how
to achieve this???

Thanks,
Chris