Click here to Skip to main content
15,898,732 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Hashcode to string Pin
Tom Deketelaere17-Jul-08 3:33
professionalTom Deketelaere17-Jul-08 3:33 
AnswerRe: Hashcode to string Pin
Guffa17-Jul-08 7:49
Guffa17-Jul-08 7:49 
AnswerRe: Hashcode to string Pin
~V~17-Jul-08 20:42
~V~17-Jul-08 20:42 
GeneralOT: sig Pin
Guffa18-Jul-08 3:29
Guffa18-Jul-08 3:29 
GeneralRe: OT: sig Pin
Paul Conrad18-Jul-08 4:06
professionalPaul Conrad18-Jul-08 4:06 
GeneralRe: OT: sig Pin
Alsvha18-Jul-08 9:07
Alsvha18-Jul-08 9:07 
GeneralRe: OT: sig [modified] Pin
~V~19-Jul-08 1:39
~V~19-Jul-08 1:39 
QuestionVery Simple Question Regarding Printing in VBA Pin
Dalek Dave17-Jul-08 1:36
professionalDalek Dave17-Jul-08 1:36 
I have an XL Macro that does mostly what I need, but I want to print just two sheets, one called "Purchase Order" and one called "Delivery Schedule".

I think I need something like ...

Sheets(Array("Purchase Order", "Delivery Schedule")).Select
Print.Selection


But I am having probs

I am not very good at vba,where am I going wrong, as this is not working!

I suspect I am not creating the Printer as an object and I don't know enough about how to do this

Can anyone help?

------------------------------------
"I want you to imagine I have a blaster in my hand" - Zaphod Beeblebrox.
"You DO have a blaster in your hand" - Freighter Pilot
"Yeah, so you don't have to tax your imagination too hard" - Zaphod Beeblebrox

AnswerRe: Very Simple Question Regarding Printing in VBA Pin
Tim Carmichael17-Jul-08 3:36
Tim Carmichael17-Jul-08 3:36 
GeneralRe: Very Simple Question Regarding Printing in VBA Pin
Dalek Dave17-Jul-08 3:44
professionalDalek Dave17-Jul-08 3:44 
GeneralRe: Very Simple Question Regarding Printing in VBA Pin
Tim Carmichael17-Jul-08 3:51
Tim Carmichael17-Jul-08 3:51 
QuestionForce the user to select Value from ShowDialog Pin
Rupsaa17-Jul-08 1:19
Rupsaa17-Jul-08 1:19 
AnswerRe: Force the user to select Value from ShowDialog Pin
nlarson1117-Jul-08 6:46
nlarson1117-Jul-08 6:46 
GeneralRe: Force the user to select Value from ShowDialog Pin
Rupsaa17-Jul-08 21:29
Rupsaa17-Jul-08 21:29 
AnswerRe: Force the user to select Value from ShowDialog Pin
Luc Pattyn17-Jul-08 7:37
sitebuilderLuc Pattyn17-Jul-08 7:37 
AnswerRe: Force the user to select Value from ShowDialog Pin
Mycroft Holmes17-Jul-08 18:09
professionalMycroft Holmes17-Jul-08 18:09 
QuestionMSMQ Private Queue Stucks Pin
Jack Black X17-Jul-08 0:00
Jack Black X17-Jul-08 0:00 
QuestionChange Image size to centimeter Pin
Rupsaa16-Jul-08 22:49
Rupsaa16-Jul-08 22:49 
AnswerRe: Change Image size to centimeter Pin
Christian Graus17-Jul-08 4:08
protectorChristian Graus17-Jul-08 4:08 
QuestionEnvDTE.DTE object Pin
Pawel Gielmuda16-Jul-08 22:26
Pawel Gielmuda16-Jul-08 22:26 
AnswerRe: EnvDTE.DTE object Pin
Scott Dorman17-Jul-08 2:22
professionalScott Dorman17-Jul-08 2:22 
GeneralRe: EnvDTE.DTE object Pin
Pawel Gielmuda17-Jul-08 3:50
Pawel Gielmuda17-Jul-08 3:50 
GeneralRe: EnvDTE.DTE object Pin
Scott Dorman17-Jul-08 4:01
professionalScott Dorman17-Jul-08 4:01 
Questiontake variable value from other form Pin
shee_dee8616-Jul-08 22:07
shee_dee8616-Jul-08 22:07 
AnswerRe: take variable value from other form Pin
dan!sh 16-Jul-08 22:15
professional dan!sh 16-Jul-08 22:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.