Sub CopyNonContiguousSelections() 'How to copy non contiguous cell ranges Set cellranges = Application.Selection 'Sets the Selected Cell as the cell range Set ThisRng = Application.InputBox("Select a destination cell", "Where to paste slections?", Type:=8) For Each cellrange In cellranges.Areas cellrange.Copy ThisRng.Offset(i) i = i + cellrange.Rows.CountLarge Next cellrange End Sub 'https://www.get-digital-help.com/2018/05/29/how-to-copy-non-contiguous-cell-ranges/
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter