Column.
 

Hello,

I need use something like:

new = range("A" + x & 2).value

when x = 2 then I need this result

new = range("B" & 2).value

Is this somehow possible?

Thanks Tom

Column.
 

Use the Cells object instead

new = Cells(2, 1 + x).Value

--
Regards,

Juan Pablo González

"TJF" wrote in message
...
Hello,

I need use something like:

new = range("A" + x & 2).value

when x = 2 then I need this result

new = range("B" & 2).value

Is this somehow possible?

Thanks Tom