+ Reply to Thread
Results 1 to 1 of 1

vba to set print area not working correctly

  1. 10-14-2015, 12:06 AM #1
    bqheng
    bqheng is offline
    Forum Contributor
    Join Date
    05-06-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    361

    vba to set print area not working correctly

    Hi, i made a button to set print area for data populated in D1:F4. It works only if the cells are not merged, but sometimes the cells D1:F4 needs to be merged to expand the size of the data populated and this causes a problem for the set print area button. I have attached some print screens for clarity of the problem im facing. As you can see, the print area actually cuts across merged cells. Can anyone help me with this?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Private sub code no longer working (print area macro)
    By rikkyshh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 10:43 AM
  2. How to set fixed print area in excel so cells within print area can still be modified?
    By VictoriaT8 in forum Excel General
    Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  3. VBA to set print range, open box asking for print qty, print, then redefine print area
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:43 PM
  4. Print Area:Can a print area automatically be defined strictly by the color of the cel
    By slovenc0417 in forum Excel General
    Replies: 8
    Last Post: 05-23-2007, 06:39 AM
  5. How do you turn off a print area for a page? (no print area)
    By Grunen in forum Excel General
    Replies: 4
    Last Post: 10-08-2005, 03:05 PM
  6. Print Area:What would be the code for setting the print area
    By wammer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2005, 02:05 AM
  7. [SOLVED] print area not working
    By Mark in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 09:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1