Print selection code doesn

[szakharov7723]

Hello, I am trying to create a code to automatically select the range (that can vary horizontally) and print it.
I tried to use this code, but it prints only 1 page regardless the amount of pages needed to print all data in range.
And I don't even understand why it limits it to 1 page.

Sub PrintSelection()
'
    Range("A1").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.PrintOut
End Sub

 

[szakharov7723]

Re: Print selection code doesn't work properly

Well I didn't finish the post, but stupid Tab triggered with no cursor and selected the post thread while I was pressing Enter. In general question in body is the same I just didn't finish the title and now I cannot edit it.

 

[JoeMo]

Re: Print selection code doesn't work properly

Have you tried stepping through your code to see if it selects the entire range you want to print? If it doesn't, here's an alternative you can try:

Sub PrintSelection()
ActiveSheet.PageSetup.PrintArea = Selection.Address
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False
End Sub

 

[MARK858]

Re: Print selection code doesn't work properly

What happens with...

Sub PrintSelection()
    With ActiveSheet.PageSetup
        .PrintArea = ActiveSheet.Range("A1").CurrentRegion.Address
        .Zoom = 100
    End With
    ActiveSheet.PrintOut
End Sub

 

[szakharov7723]

Re: Print selection code doesn't work properly

Yes, I stopped the code before print and I see that it selects it.

 

[szakharov7723]

Re: Print selection code doesn't work properly

It would just print some blank pages (probably because I have invisible formuals there) And funniest thing... still will print only 1 page of real data ( which I have on more than 1 page of print)

 

[MARK858]

Re: Print selection code doesn't work properly

By

It would just

do you mean it did just... when I tested it.... probably just the grammar but not reading right to me.

 

[szakharov7723]

Re: Print selection code doesn't work properly

not really, but it wouldn't change the meaning. So yes that's what happened

 

[MARK858]

Re: Print selection code doesn't work properly

but it wouldn't change the meaning

Yes it would, one implies that it hadn't been tested.

Afraid I have nothing to add currently as the code I posted printed out 3 pages with my data so unless you can provide any other info I don't know why it isn't printing the full area.

 

[szakharov7723]

Re: Print selection code doesn't work properly

or gives the outcome of what will happen if you execute this code