creating, concatinating, cell addresses
 

I have two cells. Both contain numbers, say x and y. How do I create a cell
address that uses one of the numbers as the column and the other as the row,
i.e cell:row x,column y
--
Mal

creating, concatinating, cell addresses
 

dim x as long
dim y as long

x = 1
y = 2
msgbox cells(x, y).value
--
HTH...

Jim Thomlinson


"Mal" wrote:

I have two cells. Both contain numbers, say x and y. How do I create a cell
address that uses one of the numbers as the column and the other as the row,
i.e cell:row x,column y
--
Mal