I've tried sheets().select and sheets().activate but when I try to take values from sheet two they still read from sheet 1.
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.
Code:
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.