Just select the multiple locations and do Ctrl+V

in code

ActiveCell.Copy _
Destination:=Range("A1,B9,C3,D5:E7,F10")

--

Regards,
Tom Ogilvy


wrote in message
oups.com...
Good day,

I would like to know how I can specify one copy location (using CtrlC)
and then mark/indicate multiple locations where the paste should take
place. Is this possable? This will beat the copy + paste procedure
times 20 that I am currently doing.

Kind regards

George