Display contents of multiple active cells in another cell?

I have a piece of code that allows me to display the contents of an active cell in another cell. However I can only view one cell at a time, if I click on multiple cells it still only displays the first cell. Is there a way to be able to display the contents of two or more cells at once?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("G24").Value = ActiveCell.Value
End Sub

Any help would be much appreciated.

Thanks

mtsykes28,

Welcome to the forum! In the future, please wrap your code in code tags (link in my sig for how)
Give this a try:

Please Login or Register  to view this content.