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

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?

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!

Greetings!!

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


Jacob (If this post helps please hit Yes)

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.

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.

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?

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?