http://j-walk.com/ss/excel/tips/tip36.htm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ABelect" wrote in message
...
I am attempting to create a macro to copy and paste. The cells I need to
copy are not adjacent to each other. I used the Ctrl key to select the
cells
but I get an error that it cannot be done. How do I select and copy these
non-adjacent cells in a macro?