Copy and Paste Between Workbooks Pastes as Image, not Formula

**japple** · 05-17-2009, 07:51 PM

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:

Please Login or Register  to view this content.

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.

**shg** · 05-17-2009, 07:54 PM

Welcome to the forum.

Looks fine to me -- post a workbook?

**japple** · 05-17-2009, 07:56 PM

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.

**shg** · 05-17-2009, 08:03 PM

I dunno. There are some odd states that persist from the user interface into VBA (an example is when you do a Find across worksheets from the UI, and then try to do a Find in VBA), but without seeing the workbook, I can't guess.

If you can't strip the sensitive data and retain a meaningful example, perhaps someone else can speculate.