Excel Selection Print Excel VB sheet

Asked By Albert Russel 240 points N/A Posted on - 05/15/2011

Hi there,

I have developed an Excel VB sheet to generate transcripts. The application is simple. But I don't know how to print the page with macro. Currently, I just copy-paste the generated transcript to Word and print it manually. This is not looking much professional. So  I would like to make it automated.

Please help.

• Status: Open
• Question Views: 1301
• Answer Count: 6
• Vote Up 24 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Simmy C-me

Go To Solution

Answered By Simmy C-me 0 points N/A #97177

Excel Selection Print Excel VB sheet

Hi Albert,

It is very simple. You just issue the command PrintOut for the specified sheet. Suppose your transcript is in sheet 1. Then the command will be:

Sheet1.PrintOut

About Simmy C-me

Questions
0

Answers
16

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 05/15/2011
• Question Category: MS Excel

Answered By Albert Russel 240 points N/A #97178

Excel Selection Print Excel VB sheet

Thanks. But this gives a print out of the whole page. I need to print some selected region in the sheet named transcript only.

About Albert Russel

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/15/2011
• Question Category: MS Excel

Answered By Simmy C-me 0 points N/A #97179

Excel Selection Print Excel VB sheet

Then you have to just issue, Selection.Print instead of sheet.printout. This will print the selected region only.

About Simmy C-me

Questions
0

Answers
16

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 05/15/2011
• Question Category: MS Excel

Answered By Albert Russel 240 points N/A #97181

Excel Selection Print Excel VB sheet

How do I select the region? I need the region to be selected automatically when I press the print button. After the region is selected, it should issue the Selection.Print command.

About Albert Russel

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/15/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Simmy C-me 0 points N/A #97182

Excel Selection Print Excel VB sheet

Something like. Range("B3:L42").Select. This will select a rectangular region, with upper left cell B3 and lower right cell L42. Hope this helps.

About Simmy C-me

Questions
0

Answers
16

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 05/15/2011
• Question Category: MS Excel

Answered By Albert Russel 240 points N/A #97183

Excel Selection Print Excel VB sheet

Thanks. It is solved finally!

About Albert Russel

Questions
1

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/15/2011
• Question Category: MS Excel