Thread: Assign relative cell reference to variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hardy[_7_] Hardy[_7_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote