quick excel question
13 November 2003, 03:42 PM
#3
Scooby Regular
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes
on
0 Posts
Like this...
=Sheet2!A1 This references cell A1 on sheet2
=Sheet2!A1:E7 This references a range, A1:E7 on sheet2
=Sheet2!NamedRange This references a named range
HTH
**Bu66er - beaten to it
Mark
[Edited by markr1963 - 11/13/2003 3:43:54 PM]
=Sheet2!A1 This references cell A1 on sheet2
=Sheet2!A1:E7 This references a range, A1:E7 on sheet2
=Sheet2!NamedRange This references a named range
HTH
**Bu66er - beaten to it
Mark
[Edited by markr1963 - 11/13/2003 3:43:54 PM]
Thread
Thread Starter
Forum
Replies
Last Post