Print all columns and certain rows

[TPDave]

Hi All,

I have a print button and have defined a start row (srow) and end row (erow) per the code below. What arguments do I use within .printout to restrict the print to these rows? All the guides I have seen so far have predefined print areas so I don't know how to handle this variable.

Please Login or Register  to view this content.

Any help would be greatly appreciated, thanks!

[JieJenn]

One way you can do is to set the print area. Assuming your last column ends at column G.

Please Login or Register  to view this content.

[TPDave]

Hi JieJenn,

I've tried your suggestion but I'm getting an error, it looks like it's not reading the range correctly. I've attached an example sheet containing the problem. Any ideas?

Thanks

[TPDave]

Got it! I used the following:

Please Login or Register  to view this content.