View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger[_8_] Roger[_8_] is offline
external usenet poster
 
Posts: 12
Default Using cell contents ae address

I have 2 colums that contain a value in the first column
and an address in the cells of the second column. The
address is in R1C1 format. I want to write VB/excel macro
that reads the contents of the address cell, goes to that
address and pastes the associated value in the new cell.
How do I do this?