Todd,

I'm not sure if you intended to have a "+" in your formula, but that could
cause a problem.
Try it with out the "+" symbol.

=OperatingRevenue!B7:B18

HTH,
Paul

"tjhorne" wrote in
message ...

I have a merged cell that spans from B:7 to B:18 (on worksheet named,
OperatingRevenue) and I am trying to get that text to display in
another worksheet (worksheet named, Upload) within the same xls file.

I am using the following function but it doesn't seem to work:

=+OperatingRevenue!B7:B18

Any ideas?

Thanks!

Todd H.


--
tjhorne
------------------------------------------------------------------------
tjhorne's Profile:
http://www.excelforum.com/member.php...o&userid=27871
View this thread: http://www.excelforum.com/showthread...hreadid=473753