Thanks to this forum I figured out how to print one cell per page with it centered. So now my question is this...how do I get it to center 'top to bottom'. I serve on the board for my local Humane Society & need to print #'s for our Pet Parade participates (think bib #s for a race).
Thanks in advance yall!
Below is what I used to get this far....
Option Explicit
Sub PrintOneCellAtATime()
Dim cell As Range
For Each cell In Intersect(Selection, ActiveSheet.UsedRange)
If Len(cell.Text) Then cell.PrintOut Copies:=1
Next cell
End Sub
Bookmarks