Hi
I've spent a few hours this morning trawling through numerous forums and posts trying to get my head around a multiple selection copy/paste issue I seem to be having.
I keep a master workbook in which I need to collate data sent to me from a number of different regions across the globe. I send out a copy of this workbook which the regions fill in then submit to me.
My problem is basically this - I wanted to run a macro that copies all the purple cells in each of their workbooks (for which I have named a range, "purplecells"), then lets me paste this data into my workbook.
With the following macro I am able to copy all of those cells (I'm still a macro beginner so plz be nice! ):
Sub SelectPurpleCellsAmericas()
'
' SelectPurpleCellsAmericas Macro
'
'
Sheets("Americas").Select
Range("purplecells").Select
End Sub
But when I select the same range of cells in my workbook then try to paste, I get the ever frustrating "That command cannot be used on multiple selections" error.
Attached is a basic version of the workbook I deal with. Admittedly the data collection process could do with a complete overhaul IMO.
Appreciate any help you can provide.
Cheers
Gigi
Bookmarks