Conditional print of Excel cells from VB
Posted on 1999-01-11
I have a VB program that accesses an Excel worksheet.
What I want to do is when I finish to send data, print ONLY the rows of cells that don't have blank or zero. For example, I make a statistic of the employees' laboral absences this year and as result I have:
Employee 1 10
Employee 2 3
Employee 3 0
Employee 4 1
How can I make to print the worksheet WITHOUT printing Employee 3?
I have VB 5.0 Enterprise ad Office 97 Pro. Thanks in advance.
As you see, I have the basics on VB, but I don't know much about Excel and VBA. Please send a simple example code.