Worksheets("Sheet2").Cells(1,1).Value

or

Worksheets("Sheet2").Range("A1").Value

The first is useful because it is easier to program the row and column
refrence in the Cell(row,col), the second is ideal if you are just picking a
specfic value only.

HTH
Cheers
Nigel

"steven" wrote in message
...
If the active worksheet is sheet1, is it possible to get the activecell
value in sheet2 without selecting it ?

Thank you