Print Preview

  • Thread starter Thread starter Philosophaie
  • Start date Start date
P

Philosophaie

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?
 
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?
 
Back
Top