MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Correct Way To A Simple Formula


Posted by Kyeton on January 18, 2002 12:08 AM

Hi,

What is the correct way to link cells in two work sheets? And why?

=(sheet!a1) or =sheet!a1

Kyeton


Posted by Brian M. on January 18, 2002 12:35 AM

Hi
The correct way is: =Sheet2!A1
I'm afraid I can't explain the reasoning though.

Brian

Posted by Kyeton on January 18, 2002 12:39 AM

Thanks

Brian

Thanks