View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
thegreeneyes thegreeneyes is offline
external usenet poster
 
Posts: 1
Default How a cell can be addressed with variable file-column?

for example :
I have A1 value as "hello"

I define A2 = "A"
I define B2 = "1"
I wish that if I type in A3 the value =A2&B2
the value I see in the A3 cell were "hello", instead what I see is "A1"

Does anyone know if it is possible to address a cell (A1) by defining the
column and the file as variables contained in other cells (in my example A2
and A3)?

Thanks

Victor