On Wed, 25 Jan 2006 10:10:45 -0600, duncan79
wrote:


All i want to do is to call up simple text fields from 1 worksheet to
another using the simple formula

=Sheet1!A2

for example however i have found that sometimes this works sometimes it
doesnt. i cannot see that i am doing anything different when it doesnt
work, to what i input when it does work. does my excel copy being buggy
or is there some rule regarding the use of this formula that i am
unaware of

please help

thanks
dunc

You'll need to be more specific when you write "doesn't work".

What does the formula you gave return when it "doesn't work"?

What is the contents of Sheet1!A2


--ron