RonMcK
07-18-2008, 11:26 AM
Please remind me of the elegant one line formula for copying a range on a worksheet in a workbook and paste to a worksheet in another workbook.
Also, can I quickly retrieve the name of a worksheet if I know its number (e.g. 4 of 14 sheets)? And, if I use .names does that return all sheet names as a delimited string?
Many thanks!
Also, can I quickly retrieve the name of a worksheet if I know its number (e.g. 4 of 14 sheets)? And, if I use .names does that return all sheet names as a delimited string?
Many thanks!