Results 1 to 5 of 5

Print only cells with data

Threaded View

  1. #1
    Registered User
    Join Date
    02-27-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    3

    Print only cells with data

    Hello-
    I have a workbook that takes information from four of it's worksheets and organizes it into a series of arrays on a fifth sheet. The arrays take up 10 columns, and a few hundred rows. I only want excel to print the actual results of the arrays instead of all the pages. (some of the pages being blank due to the arrays' formulas) The length of the data in the arrays will vary from use to use from one row to the potential end of the array depending on the information entered in the rest of the workbook.

    The solution should ideally not be a macro (VBA), and not require printing a selection of cells, or selecting to print only certain pages; i.e. printing should be as simple as clicking print. The sheet being printed will be totally locked from editing from the end user.

    Thanks!
    Last edited by Rockguy667; 02-27-2017 at 10:58 AM. Reason: typo

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Highlight cells for data entry but print workbook with no highlighted cells
    By kheino1111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2014, 06:51 AM
  2. [SOLVED] print only data and no empty cells
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2012, 11:22 AM
  3. Print only range of cells that include data, even if all cells formatted
    By liam_bettinson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2012, 09:41 AM
  4. Print cells with data populated
    By mccrimmon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2007, 02:06 PM
  5. [SOLVED] How I print only the cells with data without selecting everytime?
    By tkagate in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2006, 04:35 PM
  6. Replies: 1
    Last Post: 04-19-2005, 06:06 PM
  7. [SOLVED] macro to print line graph from data in cells
    By WSIB#1 in forum Excel General
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1