Copy multiple selections in excel 2003

In Excel you can make multiple selections in a spreadsheet by holding down "ctrl" while making selections, however normally Excel does not allow you to then copy these selections all at once and paste them elsewhere. I found a tip that suggests that this may in fact be possible using VBA (http://www.j-walk.com/ss/excel/tips/tip36.htm) however the tip is quite old and it does not seem to properly work in Excel 2003. In my testing, it would not copy the entirety of the first selection--instead copying and pasting just the very bottom right cell--but it would properly copy and paste the rest of the selections in their entirety (with it handling a total of 5 selections). Admittedly I did make some modifications to the code to suite my own needs and as such I have attached the modified code to this post. Did I break the code and if so how or is this approach just not compatible with Excel 2003 and if so are there other ways of accomplishing this? Thanks!

Please Login or Register  to view this content.

Originally Posted by shg

Welcome to the forum, John.

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why.

Gee thanks Mr. Moderator for the warm welcome. What does it take for someone to get some help around here?