Computing.Net > Forums > Windows XP > VB print button help!!!

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

VB print button help!!!

Reply to Message Icon

Name: midmac
Date: February 7, 2005 at 10:13:33 Pacific
OS: xp
CPU/Ram: 512
Comment:

im trying to make a button that prints only a small part of a spreadsheet. I can use Visual basic quite well but need the ciode to work this.



Sponsored Link
Ads by Google

Response Number 1
Name: midmac
Date: February 7, 2005 at 10:18:12 Pacific
Reply:

i can select the cells i want using vb but i dont know how to print only the selected cells


0

Response Number 2
Name: snipes
Date: February 7, 2005 at 10:38:36 Pacific
Reply:

wow i thought i was on the xp forum ...


0

Response Number 3
Name: rhawk7938
Date: February 7, 2005 at 17:34:20 Pacific
Reply:

Something like this:


ActiveSheet.PageSetup.PrintArea = "$A$1:$J$53"


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows XP Forum Home


Sponsored links

Ads by Google


Results for: VB print button help!!!

Letters 1 inch high print in Word www.computing.net/answers/windows-xp/letters-1-inch-high-print-in-word/147891.html

Printing problems in Xp www.computing.net/answers/windows-xp/printing-problems-in-xp/24163.html

colour printing only HELP PLEASE!!! www.computing.net/answers/windows-xp/colour-printing-only-help-please/133319.html