Thread: Copy and Paste Between Workbooks Pastes as Image, not Formula

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.

Originally Posted by shg

Welcome to the forum.

Looks fine to me -- post a workbook?

Thanks

I can't really, unfortunately, as it contains specific business stuff that I'd probably be in trouble for posting.

Do you think that would be the issue though, something about the workbook which is causing it to do this?

Sorry.