Hi guys,

This is my first post so please try to bear with me if I make some kind of forum faux-pas. I have read all the rules but you know how the internet can be.

I'm trying to write a simple app to take some data from one spreadsheet, copy it, and paste the formulas into another spreadsheet. When I do this, the cells are copied into the other spreadsheet as a picture. This is definitely not what I want, below is my code:

[WorkbookName].Sheets([SheetName]).Range([Range]).Copy
startRange.PasteSpecial xlPasteFormulas
startRange is just a range object I created.

The only things different about this scenario is that the range I am copying is a whole bunch of cells, whereas startRange is like "A3" (ie. one cell), although you can do that manually in Excel anyway, so I can't see how that would change anything.

Hope you guys can help.

Thanks.