how to slect a worksheet for the macro to read a range from

[fezzer]

I've tried sheets().select and sheets().activate but when I try to take values from sheet two they still read from sheet 1.

b = Application.Min(Range(Cells(Z, p), Cells(Z, p)))

when I try worksheets("sheet2") within the above code it return an error message so I am well and truly puzzled and would appreciate if anyone could shed some light on this for me please.

 

[Andrew Poulsom]

Try:

With Worksheets("Sheet2")
    b = Application.Min(.Range(.Cells(Z, p), .Cells(Z, p)))
End With

You need to qualify both the Range and the Cells properties.

 

[fezzer]

Try:

With Worksheets("Sheet2")
    b = Application.Min(.Range(.Cells(Z, p), .Cells(Z, p)))
End With

You need to qualify both the Range and the Cells properties.

cheers, worked perfectly!