Printing using vba

[j_Southern]

I have written the following code to enable the printing of a selected area of a large worksheet

Please Login or Register  to view this content.

It does not work.
The computer seems to go into a loop at the line .PrintArea = Range(RName).Address
The only way I can get going again is by restarting.
Where have I gone wrong?
John

[rollis13]

You haven't given enough information. It would be interesting for you to know what information you are passing to the variable RName.
Enter a stop (F9) on the first line of code in that macro. Launch your print and when the macro stops in Debug on that line see if the contents of RName are consistent with the print area.

[j_Southern]

rollis13,
Thank you for your interest. I put in a stop as you suggested and found RName to have as its value the name of the range I wished to print. When I went past the stop the printing carried on as I wished it to. It seems likely that the fault was in the printer not the code. I am sorry that I wasted your time.
John

[rollis13]

Why do you say 'wasted your time', I'm glad having been of some help.

[TMS]

Try either of these approaches:

Please Login or Register  to view this content.