+ Reply to Thread
Results 1 to 2 of 2

need scripting help, dont kn ow anything

  1. #1
    Registered User
    Join Date
    10-06-2006
    Posts
    1

    need scripting help, dont kn ow anything

    Well i got your site at google, and i need help big time and asap.

    I want too make a print button to print a standard selection. This selection is too be exactly: LENGTH: B2 until B54 and WIDTH: B54 until O54

    Plss replay asap and i dont know anything about scripting soo a very good noob guide would come handy!

  2. #2
    Forum Contributor Stuie's Avatar
    Join Date
    09-17-2006
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2003/2007
    Posts
    432
    well im not entirley sure if this is the best way to do it but it shud work....

    Range("B2:O54").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

    giv that a try

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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