I'm looking for help in writing a macro to copy a named range of cell
(1 row by 12 columns named "Scores") on Sheet 1 of my workbook an
paste it in the active cell on any sheet from Sheet 3 to 7.

I plan to put a button on each of Sheets (3-7) and execute the macr
after making the appropriate target cell active. I know I could writ
a separate macro on each of the target sheets but is there a way t
write one macro that will do the job from each sheet and assign th
same macro to each button

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