simple question

  • Thread starter Thread starter Iain Wicks
  • Start date Start date
I

Iain Wicks

Hi I want to reference a cell in another worksheet and
can't quite get the syntax right.
This is what i did when i want to display the contents of
A14 in Sheet 2.
=('sheet 2',A14)


Can you help
 
You're almost there :-)
The syntax is
=('sheet 2'!A14)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Back
Top