Dear Amnon,

If your predetermined cell is say A1 ,

then right click on sheet tab select view code, in worksheet
,selectionchange event put following code

Range("A1") = ActiveCell.Value

H S Shastri


++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++


"Amnon Wilensky" wrote:

Hi,
Is it possible to pass data from any cell on the spreadsheet by clicking on
it, to a predetermined fix cell?

Thanks,

Amnon