My guess is that this is easy and you will laugh but I'm just starting out in excel.

Range("F4").Select
Selection.Copy
Range("(D4)4E4)4").Select
ActiveSheet.Paste

I want to use the letters that are currently in the cells D4 and E4 (found through a hlookup) to be used in the range that is selected. Any advice would be greatly appreciated.