How do I print each cell of a worksheet to a page. That is one cell to
one piece of paper.
This is for an odd little task a fellow co-worker needs to do.
He is currently doing it by hand but I assume this is something VBA
should be able to do easily.
(I am not an Excel user but am quite familiar with VBA and Access)

Select all the cells you want to print one at a time and run this macro

Sub PrintSelection()
Dim cell as Range
For each cell in Selection
cell.printout
Next
End Sub


do alt+F11 to go to the VBE (VB Editor). Then insert=Module from the memo
and paste in that code. Then go back to excel and you can select the macro
in Tools=Macro=Macros, select the macro and hit run (after you select the
cells).


--
Regards,
Tom Ogilvy


"asc4john" wrote:

How do I print each cell of a worksheet to a page. That is one cell to
one piece of paper.
This is for an odd little task a fellow co-worker needs to do.
He is currently doing it by hand but I assume this is something VBA
should be able to do easily.
(I am not an Excel user but am quite familiar with VBA and Access)