ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Display a list (https://www.excelbanter.com/excel-discussion-misc-queries/147274-display-list.html)

N.F[_2_]

Display a list
 
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

Don Guillett

Display a list
 
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




All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com