From: ABelect on
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?
From: Don Guillett on
http://j-walk.com/ss/excel/tips/tip36.htm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"ABelect" <ABelect(a)discussions.microsoft.com> wrote in message
news:98AECC0F-85E2-4390-98D6-D0CCAEC739FA(a)microsoft.com...
>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?