Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
which declaration to use
I have a very strange problem.
I created a little program, which adds worksheets and give it the sam 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 ne sheet. Now the strange thing is, that on one computer this program doesn' give any problems. It simply copies everything (values, format, border - everything!) and paste the selection exactly where I want it. But now I want to let this same program work on another computer, bu now suddenly it won't work. Visual basic starts complaining that what want is out of the scope of my project! I tried to solve this by making the sub public instead of private, bu still it won't work! And still on the other computer it does work, n 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, Pee -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Declaration. | Excel Discussion (Misc queries) | |||
Workbook Declaration | Excel Discussion (Misc queries) | |||
VBA - variable declaration | Excel Discussion (Misc queries) | |||
Declaration? | Excel Programming | |||
Variable Declaration?? | Excel Programming |