Assign relative cell reference to variable
 

Hi,

I have loop in which I want to assign the address (A1 format) of th
cell 1 row below the active cell (which naturally changes during th
loop) to variable, so that I can use the variable for reference i
ACTIVEWORKBOOK.NAMES.ADD.

Tried various things, but seem to be going round in circles. I am sur
there must be an easy way.

Thanks in advanc

--
Message posted from http://www.ExcelForum.com