Paste question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet in which I have added one piece of code to a VB module
(GetFormula). This file also contains many formulas. Other than those two
things, I just have straightforward data and formatting in various cells.

Now when I try to paste into this sheet from another file, I get a VB message:

"File not found"

If I click OK, this message appears:

"Microsoft Excel cannot paste the data"

However, the data is pasted into the target cell(s).

If I click Help, this topic appears:

"Can't find specified file."

What's going on?
 
I figured it out -- copying and pasting between multiple instances of Excel
is apparently undependable. When I open up both of my spreadsheets within
the same instance of Excel, copy/paste behave normally.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 1
Excel Data pastes into 2 cells not 1 1
using the =page! feature to transpose a row to column 0
want to track time while paste value in multiple column of same roe 1
Copying and pasting with SUMIF and COUNTIF 3
Cut & Paste in Excel without erasing cell borders? 1
Paste special from cells without formulas/formats 2
Paste Delimited 8

Back
Top