ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing in Visual Basic (https://www.excelbanter.com/excel-discussion-misc-queries/31330-printing-visual-basic.html)

bjh96

Printing in Visual Basic
 

What's the syntax to print in visual basic? Specifically, how do I print
a separate worksheet in the same document?


--
bjh96
------------------------------------------------------------------------
bjh96's Profile: http://www.excelforum.com/member.php...o&userid=24355
View this thread: http://www.excelforum.com/showthread...hreadid=380195


Dave Peterson

worksheets("sheet2").printout

Lots of times, you can record a macro when you do this and see the code you'd
want to use.

bjh96 wrote:

What's the syntax to print in visual basic? Specifically, how do I print
a separate worksheet in the same document?

--
bjh96
------------------------------------------------------------------------
bjh96's Profile: http://www.excelforum.com/member.php...o&userid=24355
View this thread: http://www.excelforum.com/showthread...hreadid=380195


--

Dave Peterson


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com