Results 1 to 2 of 2

Thread: Printing

  1. Jul 11th, 2000, 09:37 AM #1
    Stephen Warker
    Stephen Warker is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 2000
    Posts
    23

    Wink

    How do I print in Excel using VBa only the cells that contain data?

    Steve
    Stephen Warker
    Reply With Quote Reply With Quote
  2. Jul 11th, 2000, 11:53 AM #2
    HDR
    HDR is offline
    Addicted Member
    Join Date
    Jan 2000
    Location
    Fresno, California, USA
    Posts
    195
    Use this:

    Worksheets("Sheet1").PageSetup.PrintArea = "$A$1:$C$5"
    Worksheets("Sheet1").Printout
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width