Copying Data from One Sheet to another

  • Thread starter Thread starter Greg Hadrych
  • Start date Start date
G

Greg Hadrych

I have a workbook that contains about 10 sheets. With
this workbook, I have macro buttons to take you from one
page to another. Many times, I will need to take data
from one page to another to continue working on it. When
I go to copy the data, change pages, and then paste the
data, it will not copy. When I go back to the source
page, the data no longer has the flashing lines around
it.

There is also a little VB coding in the pages, nothing
more though then showing formula bar, status bar, etc.

Here is the kicker, when I put the workbook into design
mode, I can copy the data like normal. I am at a loss as
to what is causing this problem. Has anyone come across
this before?
 
Many VBA functions clear the Excel clipbard in WinXL (MacXL's clipboard
is persistent).
 
Back
Top