HI, I am new to excel and this group so treat me kindly :-)

I want to add some VB code to transfer the cell location on one sheet to
another.

That is on sheet1 in cell A1 via VB code I want to insert in that cell
"=sheet2!c3" so that A1 is always the value of sheet2!c2.

I am using a ListBox to get a value of a list and put it in 'Reff'.

The list in sheet 'Constants' is range A3 to A10, so a 3 in Reff points to
Constants!A5.

In 'Selection.Cells(1).Offset(0, 1)' I want to end up with "=Constants!A5".
How do I get there from here?

Thanks for any help you can give me.

Also can you reccomend a good book (no, not Harry Potter....)

---------------code snip --------------------

Range("Reff") = lstSelection.ListIndex
Selection.Cells(1) = lstSelection.Text 'this works fine
Selection.Cells(1).Offset(0, 1) = 'what do I put here???
---------------------end snip

--
brian