For a company planner I am looking for a marco that copies a cell range (already merged) to a position vertically somewhere above or vertically below (with no horizontal shift!).

It starts with question "select range to be copied" then "select destination"

If the user clicks a destination somewhere aborve or below, then macro pastes the selected cell range exactly vertically under it, eventhough the uses clicks with a horizontal shift.


A second command button does the same in horizontally, with the different that the copied cell range is always 14 columns to the right. Consists of only one question: "Select cell range to be copied to next day"

Bart