Could someone help me to do the following:
I need to copy (or using a similar VBA function) a range of cells to another worksheet. 

However, the range will probably include empty cells that I don't want to include with the data, and I also need to **insert** the values (rather than Paste) so they don't override stuff already on the destination sheet.
`.Value` rather than `.Paste` or `.PasteSpecial` is preferred.

Hope this makes sense

---

EDIT
----

Here is some code I have tried, but this still overrides (even if the selected cells were empty) the data in the destination sheet.

```
Sub MakeQuote()
Application.ScreenUpdating = False
  Sheets("Code Input Sheet").Range("A9:C800").Copy
  Workbooks.Open("C:\Users\j\Documents\Trial.xltm").Activate
  Sheets("Special Quote").Range("A4").PasteSpecial xlPasteValues, skipBlanks:=False
  Application.CutCopyMode = False
Err_Execute:
    If Err.Number = 0 Then MsgBox "Copying Successful :)" Else _
    MsgBox Err.Description
    Application.ScreenUpdating = True
End Sub

```

So basically it needs to find just the data and copy/insert it into the destination sheet.

Being used to HTML and PHP this is a bit of a jump in the dark for me :)

Many thanks everyone