Hi;

This may be a solve in code or without code.. (i can read the code fro
the macro generator then.).

The situation is as follows; Excel 2000.
-
File1
Sheet1 = Sheet1
Sheet2 = Test
Sheet3 = Sheet3

Test!b1 = 10
Sheet1!b1 = =Test!b1


File2
Sheet1 = Sheet1
Sheet2 = Test
Sheet3 = Sheet3
-
Now.. I copy [File1]Sheet1!b1
I go to [File2]Sheet1!b1 and I paste.

I now get:
=[File1]test!B1 as a result in that cell.
I DO NOT WANT THIS. I ONLY WANT: =TEST!B

How do I prevent excel from being too smart and copying filenames i
forumale references? I'll have to put it in code.. but click thourg
instructions will do too. Thanks

sd
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message381926.htm