Print two ranges to one page

[antcha]

is there a way to print two ranges, A1:A28 and H1:H28, to one page? I currently have a user form that is to be used to print out these ranges. The first range is the description range with the second range showing the tallies per line against the description. At present using the following code, it prints out on separate pages.

Please Login or Register  to view this content.

Any help will be appreciated

[mangesh.mehendale]

Please Login or Register  to view this content.

[antcha]

Sorry, my friend, but this does not seem to work for me. Your example prints out in one long column whereas I need to print column h alongside column a

[mangesh.mehendale]

try this one

Please Login or Register  to view this content.

[antcha]

my lack of knowledge is showing here, but how would that fit into the commandbutton, (Private Sub July_Click()), I have shown in my query? When viewing the print screen in your sheet, it appears to be printing in one long column instead of side by side.

[mangesh.mehendale]

Hiii Second code is showing side by side... see in attached sheet...
Also let me know why are you using private sub??

[antcha]

YES, that works well, thank you very much. The reason for the private sub is my lack of knowledge.

[mangesh.mehendale]

Ok Then mark this thread as solved.. (See at top thread tools)
Change title little like " Print Multiple Ranges Side by Side"
Hit on Add Reputation to the ans if anyone helps from forum...

[antcha]

This now raise another problem. I have set the workbook as hidden so that only the userform is visible. The print setup screen is opening behind the userform so that it cannot be accessed now

[mangesh.mehendale]

Please attach sample file...

[antcha]

July print Sessions.xlsm
As can be seen, I am trying to have the July commandbutton print the report in side by side columns on one page. This needs to be done without any interaction from the user. The work book remains hidden from the user so that they cannot alter anything on the work sheets. The password to enter the work book is "password".
I apologise for being a nuisance but I hope to finish this before I retire which is very soon.

[mangesh.mehendale]

I think print preview not possible with userform

change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[antcha]

Sorry for the delay in responding as I am away from work. This is the solution I am looking for, thank you for your effort.