Hi,

How can I make refer to a cell in a certain worksheet (say the 3rd one
listed), without referring to it by name, as it will vary? I'd like to
be able to do this in formulas in Visual Basic, so basically say:

Cells(1,1).Value = Sheets("[name]").Cells(1,1).Value

Thanks!
Brett