Searched all day for this same issue - heres a solution i found... https://www.reddit.com/r/excel/comments/43z7cg/how_do_i_paste_multiple_set_of_ranges_as_image_in/