S Sprooty Daemon Poster Messages 769 Oct 2, 2005 #1 Hello, I need some help with a Spreadsheet problem, so anyone with good knowledge please help me. When i enter "=Range(A1:A5)" i get "#Name?" A1 and A5 been cell positions
Hello, I need some help with a Spreadsheet problem, so anyone with good knowledge please help me. When i enter "=Range(A1:A5)" i get "#Name?" A1 and A5 been cell positions
office politics It's all just 1s and 0s Messages 6,555 Location in the lab Oct 2, 2005 #2 what cell are you entering this formula into? name usually means a bad cell reference. this could be a circular cell reference though
what cell are you entering this formula into? name usually means a bad cell reference. this could be a circular cell reference though
OP OP S Sprooty Daemon Poster Messages 769 Oct 2, 2005 #3 I have uploaded it to the web so you can have a look. http://www.savefile.com/files.php?fid=7623800 If you type "=RANGE(B7:K7)" in cell P7 it will give u "#NAME?" instead of the answer.
I have uploaded it to the web so you can have a look. http://www.savefile.com/files.php?fid=7623800 If you type "=RANGE(B7:K7)" in cell P7 it will give u "#NAME?" instead of the answer.
office politics It's all just 1s and 0s Messages 6,555 Location in the lab Oct 2, 2005 #4 i dont see range in my function list. im using openoffice though. goto insert | function and try to find it, but ill bet its not there
i dont see range in my function list. im using openoffice though. goto insert | function and try to find it, but ill bet its not there
OP OP S Sprooty Daemon Poster Messages 769 Oct 2, 2005 #5 Hmm, thanks ill have a look and see if theres another command that means range..