Hi, Can anyone tell me if it is possible to name and define a range made up of cells from different parts of the file?

eg

MyRange=C1, D4, F1, C6, H9, B6, B9

and paste then in that order into another excel file? If so, what is the syntax?


Thanks.

Talāt