'If you are looking for a formula; In Sheet2 Cell B1 place
=MAX(Sheet1!A1:A10)

'VBA
Sheets("Sheet2").Range("B1") =
Worksheetfunction.Max(Sheets("Sheet1").Range("A1:A 10"))

If this post helps click Yes
---------------
Jacob Skaria


"sam" wrote:

Hi All,

I have a sheet1 where data is diaplayed in column A based on a formula, Now
the data can be displayed anywhere between cell A1 and A10,
What I want to do is: I want to display this value from Sheet1(A1:A10) in
Sheet2 Cell B1

So basically it is a range of cells on sheet1 in column A that the value can
be displayed(it is random) and I want to display that value in Sheet2 Cell B1

Hope I made it clear

Thanks in Advance