Printing Excel Cell Selection -Troubled Novice Needs Help

03-05-2004, 07:27 AM

uglykidjoey uglykidjoey is offline

Newcomer

Join Date: Mar 2004

Posts: 4

Printing Excel Cell Selection -Troubled Novice Needs Help

Hi everyone!

how can i print a selection on an active worksheet in visual basic code? for example, i want to print all the values within the range A1 upto Z100?

how can i setup my printer for such action in VBA?

many thanks

03-05-2004, 07:33 AM

Jotham

Newcomer

Join Date: Feb 2004

Posts: 16

Here's an example you can work with to fit your needs.
Depending on how you want to make the request to print. Below uses a button_click to make the request.

Private Sub PrintSheet_Click()

Sheets("Name of Sheet").PageSetup.PrintArea = "$A1:Z100"
Sheets("Name of Sheet").PrintOut

End Sub

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel: Cell (Due Date) <= Date	CodeRed	Excel	9	11-28-2003 04:22 AM
Pause VB to select a cell in Excel.	rpoy	Excel	4	09-22-2003 10:20 AM
Help using automation in excel with advanced cell handling	_VBA_Addict	Excel	4	06-18-2003 12:48 AM
Excel Selection Probelm	xzer0cool	Word, PowerPoint, Outlook, and Other Office Products	1	06-06-2002 01:15 PM
Lets See Who can Do this in Excel	webking	Word, PowerPoint, Outlook, and Other Office Products	1	01-25-2002 07:07 PM