Print one cell to one page

[asc4john]

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)

 

[Guest]

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).