title: VBA How to get Multiple Selections with .Selection
body: <p>I haven't been able to find a helpful solution to this. Maybe someone on here might know the answer. My macro requires the user to have a source and destination cell. To do this the selects the source, and then hold ctrl and clicks another cell. This creates multiple selections and I can't seem to access both of them. When I use the Selection range I only have the first cell in the range. Is there another selection range, or how can I get the 2nd cell? Does anyone have a clue?</p>