discontinuous print area

  • Thread starter Thread starter kildevil
  • Start date Start date
K

kildevil

I am relatively inexperienced in Excel. Is the a method to enter dat
into a spreadsheet and only print the rows that contain data. I have
spreadsheet the a group uses as a form. Validation is used for eas
entry. Not all rows contain data every time the form is completed.
have recorded macros and done limited editing, but do not know how t
attempt this. I would like to use a button to allow the user to nam
and save the file,& print the rows with data.

Any help will be greatly appreciated
 
If you can pick out a column that always has data, I'd use
Data|filter|autofilter and then only show the nonblanks. Print that, then
data|filter|showall.

It's not quite a macro, but it can be used for lots of stuff--not just printing.
 
Back
Top