Peer,

Exactly what does the error message say, and on what line of code
is the compiler complaining?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Peer " wrote in message
...
I have a very strange problem.

I created a little program, which adds worksheets and give it
the same
lay-out every time.
I did this in my personal macro workmap.
The program copies one or two pages of this personal workmap to
a new
sheet.

Now the strange thing is, that on one computer this program
doesn't
give any problems. It simply copies everything (values, format,
borders
- everything!) and paste the selection exactly where I want
it.
But now I want to let this same program work on another
computer, but
now suddenly it won't work. Visual basic starts complaining
that what I
want is out of the scope of my project!
I tried to solve this by making the sub public instead of
private, but
still it won't work! And still on the other computer it does
work, no
matter private or public. I looked almost everywhere for
differences,
but I can't find any!

What is wrong? I'm going slightly mad!

tnx in advance for any help,

Peer


---
Message posted from http://www.ExcelForum.com/