Print Preview
 

After I call a Print Macro I have made. How do I not have a Print Preview
come up?

Print Preview
 

Worksheets(1).PrintOut Preview:=False
Also, see...
http://support.microsoft.com/KB/555375
"How to Ask a Question"
--
Jim Cone
Portland, Oregon USA



"Philosophaie"

wrote in message
After I call a Print Macro I have made.
How do I not have a Print Preview come up?

Print Preview
 

I am also having trouble with ranges. I need to select a range based on a
subroutine calculating a variable row numbers. I eventually want something
like this:

Range("B2:G21").select

for a print. B2 & G21 needs to be inputed a variable range from a string:

rangestart = "B" & m
rangeend = "G" & n
(where m & n are integers)

This is what I have so far. Any other methods are welcomed!

Print Preview
 

Greetings!!

Please try Range("B" & m & ":G" & n).select


Jacob (If this post helps please hit Yes)

Print Preview
 

Tryed:

Range("B" & m & ":G" & n).select

Error code is "Method 'Range' of object'_Worksheet' failed"

and

Range("B" & m :"G" & n).select

The error code says Compile error: "Expected: list separator or )".

M and n are integers.

Print Preview
 

This is correct......

Range("B" & m & ":G" & n).select

Your error suggests that either the worksheet or range you are trying to
select is protected, and you are not specifying the worksheet so VBA is
assuming it is the current active worksheet, is that what you want?

--

Regards,
Nigel




"Philosophaie" wrote in message
...

Tryed:

Range("B" & m & ":G" & n).select

Error code is "Method 'Range' of object'_Worksheet' failed"

and

Range("B" & m :"G" & n).select

The error code says Compile error: "Expected: list separator or )".

M and n are integers.

Print Preview
 

Range("B" & m & ":G" & n).select

That worked. Now I would like to know how to print to an external printer
the range I created. How do I do that?

Print Preview
 

Start a new thread and be clear what you are asking.

Try taking a look here to phrase questions that will get a polite answer....

http://support.microsoft.com/KB/555375
--

Regards,
Nigel




"Philosophaie" wrote in message
...
Range("B" & m & ":G" & n).select

That worked. Now I would like to know how to print to an external printer
the range I created. How do I do that?