Forget about Camera tool.
Use File|PageSetup and on the Sheet tab specify Row and Column headers are
to be printer. Return to sheet
Select the range to be copied. Hold down Shift and use menu command
Edit|Copy Picture (this shown only when Shift is held down); specify As
Printed
Now you have the picture on clipboard. Move to Word and use Paste or Paste
Special
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"nospaminlich" wrote in message
...
I'm trying to copy a picture of part of a spreadsheet into a Word
document.

The Camera function found in Tools\Customise\Commands\Tools almost does
the
trick but I particularly want to include the Row and Column headings so
it's
easy to refer to particular cells or ranges.

Can Camera be used to show Row and Column headings as well as cells and,
if
so, how?

If not, what is the easiest way of achieving what I want to do?

Thanks a lot