Automatically hide rows when printing

M

Manuel Murieta

I have a worksheet with 100 rows and 1 column. Some of the cells contain
data whereas some of the cells are blank. (All of the cells contain
formulas.) When printing I would like the printing to print only the cells
that are not blank and not leave spaces for those cells that are not blank.
Is there a macro that I could use to perform this?

A
1 ball
2 cube
3 TV
4
5
6 radio
7 table

I want the printout to be:

ball
cube
TV
radio
table


not the following:

ball
cube
TV


radio
table
 
J

Jonathan West

Hi Manuel

It looks like you are working with an Excel worksheet, not a Word document.
This group deals with programming for Word.

The Excel programming experts hang out in
microsoft.public.excel.programming, and are far more likely to have an
answer for you.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Hide columns based on row values 2
Cannot bring rows to Height 1 in Print view 0
Appending problem after splitting field 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Arriving at totals 2
Insert Index into a Table 1
Pasting a Table from Excel to PP: please help! 1

Top