What Does This Function Do?
 

I have a spreadsheet with the following function:-

BB!G1

What does it do please?

Thanks.

It gets the value of cell G1 in worksheet BB.

--
HTH

Bob Phillips

"Saxman" wrote in message
...
I have a spreadsheet with the following function:-

BB!G1

What does it do please?

Thanks.

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.

--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Saxman" wrote in message
...
I have a spreadsheet with the following function:-

BB!G1

What does it do please?

Thanks.

"Saxman" wrote in message

I have a spreadsheet with the following function:-

BB!G1

What does it do please?

Thanks.

It refers to Cell G1 on Sheet BB

Gordon wrote:

It refers to Cell G1 on Sheet BB


That's what I thought, but there isn't a sheet BB.

At least that has partly answered my problem.

Thanks.

"Saxman" wrote in message

Gordon wrote:

It refers to Cell G1 on Sheet BB


That's what I thought, but there isn't a sheet BB.

At least that has partly answered my problem.

Thanks.

Are you sure there isn't a hidden sheet? If there was no sheet, that cell
would return a value of #REF