=formula1&" - "&formula2

where formula1 is the workbook name formula and formula 2 the worksheet name
formula


--

Regards,

Peo Sjoblom

"mikeburg" wrote in
message ...

Peo Sjoblom's vba works great!

One last request.

What formula would you recommend to show only the workbook name &
worksheet name in a cell (A3 or whatever) separated only by a hyphen -
For example for a workbook named Payroll with a sheet named Rates:

Payroll-Rates

Thanks a million. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=482983