Have you tried recording a macro to see what is happening. A good way to
learn.

--
Don Guillett
SalesAid Software

"N.F" wrote in message
...
In excel, How can I make a code such that when I click a command button,
the
program copies and paste a given range of ten by ten list:

Example assuming this is the 10x10 list i need to copy and paste somwhere
else in the same worksheet.:




"TYD" "DFKD" "DD" "DK" "DF" "DJ"
"J" "ER" "IODE" "DE" "KL" "KD"
"W" "DD" "JKDDD" "LK" "DD" "ER

Anyone? Hopefully my question makes sense