Good day, I am stumped on a vba challenge for a couple of days now. As part of a larger merge macro, I had been using the following code to select a range of cells: 

With mybook.Worksheets(1)
                    Set sourceRange = .Range("A1:I28")
                End With

However for a new project I need to select five specific cells F1, G2, C7, G7, C8 (as opposed to A1:I28) and was hoping to use a modified version of the existing macro.


Any ideas would be greatly appreciated!

Thanks!