+ Reply to Thread
Results 1 to 1 of 1

create print file after hiding blank rows in data range.

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    25

    create print file after hiding blank rows in data range.

    Friends,
    I have created bill copy in excel format which goes in to multiple sheets. I use separate macro for different sheets to hide blank rows to hide rows in which quantity or amount is 0. Also use another set of macros to un-hide rows in multiple sheets.
    What I want-
    1) to have one macro to work on multiple sheets (not all) (Predefined in macro) to hide blank rowwithin different ranges in different sheets (Ranges to be defined in macro for each sheet)
    2) Un-hide rows in multiple sheets (not all)
    3) Create and save pdf print file of multiple sheets in pre-defined sequence (in macro itself) after running macro for hide rows.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need some help please - Macro to create a CSV file and remove blank rows.
    By stuhelhall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2016, 09:34 PM
  2. Replies: 4
    Last Post: 09-16-2014, 10:48 AM
  3. How to create a macro to insert blank rows and copy data into blank rows?
    By zodiack101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2013, 01:18 PM
  4. Dynamic Print Range not including blank rows with formulas
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 11:49 AM
  5. Mac Excel: Hiding rows if cell blank, when being blank depends on a conditional formula
    By lee_5_5 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-06-2013, 11:25 PM
  6. hiding blank rows based on a blank cell
    By Snapon61 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2011, 09:36 PM
  7. [SOLVED] Can I create a macro to identify and delete blank rows in a range?
    By carlsondj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-09-2005, 08:05 PM

Tags for this Thread

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