I'm trying to get the macro to let me pick the name on the worksheet t
paste the info into. Here's what i have but it gives me an error
(run-time error '9' subscript out of range)

Help a newbie please! :)


Windows("CUP_Results.xls").Activate
Sheets("Pro Calc").Select
Range("A1:AF100").Select
Selection.Copy
Sheets(strWorksheet = InputBox("Please enter the name of th
worksheet")).Select
ActiveSheet.Past

--
Message posted from http://www.ExcelForum.com