What code could I use to select cell A1 in the last sheet? I have
variable quantities of sheets and the sheet names can be changed. So I
guess its something like Worksheets(xxx).Select, but how do I know the
last number?
Thanks
Sean - 29 Nov 2007 17:02 GMT
Ok, just spotted an archived post, that does the trick
Dim i As Integer
i = Sheets.Count
Sheets(i).Select
Very clever