S Saxman Aug 3, 2005 #1 I have a spreadsheet with the following function:- BB!G1 What does it do please? Thanks.
A Arvi Laanemets Aug 3, 2005 #3 Hi Maybe =BB!G1 When yes, then it isn't a function, it is a cell reference - a value from cell G1 on sheet BB is returned.
Hi Maybe =BB!G1 When yes, then it isn't a function, it is a cell reference - a value from cell G1 on sheet BB is returned.
G Gordon Aug 3, 2005 #4 Saxman said: I have a spreadsheet with the following function:- BB!G1 What does it do please? Thanks. Click to expand... It refers to Cell G1 on Sheet BB
Saxman said: I have a spreadsheet with the following function:- BB!G1 What does it do please? Thanks. Click to expand... It refers to Cell G1 on Sheet BB
S Saxman Aug 3, 2005 #5 Gordon said: It refers to Cell G1 on Sheet BB Click to expand... That's what I thought, but there isn't a sheet BB. At least that has partly answered my problem. Thanks.
Gordon said: It refers to Cell G1 on Sheet BB Click to expand... That's what I thought, but there isn't a sheet BB. At least that has partly answered my problem. Thanks.
G Gordon Aug 3, 2005 #6 Saxman said: That's what I thought, but there isn't a sheet BB. At least that has partly answered my problem. Thanks. Click to expand... Are you sure there isn't a hidden sheet? If there was no sheet, that cell would return a value of #REF
Saxman said: That's what I thought, but there isn't a sheet BB. At least that has partly answered my problem. Thanks. Click to expand... Are you sure there isn't a hidden sheet? If there was no sheet, that cell would return a value of #REF
