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