Hi Alex,

Try:

Sub Tester()

Sheets("Sheet1").Range("B10:C17").FormulaR1C1 = _
"=Sheet2!RC[4]"
End Sub


---
Regards,
Norman



"Alex Martinez" wrote in message
...

Hi,

I am using Excel 2002 and I want to do a macro that will cell reference
from one worksheet to another. For example I want Sheet 1 cell B10:C17 to
be able to reference from Sheet 2 F10:G17. I don't want to do a copy and
paste, because the user may change the data in Sheet 2. Any tips or
suggestion will be appreciated. Thank you in advance.