How do I automate printing ...
of s/sheet with 100 rows, and 30 cols, when all I ever want is Col-A plus any
5 neighbouring cols? - but only those rows within the 5, which have a
colour-attribute applied?
Can anyone help with VisBAS code to display a dialogue box which prompts
user for the 5-col span, and then sifts out those rows within the 5cols which
have NO coloured cells?
(To explain: the s/sheet shows all staff names in Col-A, plus columns for
each day of the month (1-31st). Wenever someone plans time off, the
corresponding cell is colour-filled. Admin Dept. req. a list printed at
start of each week to show who is absent).
Thanks for any help offered - in anticipation!
|