save ranges ( multiple sheets)

[mena]

hi

if i have ranges

sheets(1).range(a1:f3)

and

sheets(3).range(c2:g6)

i need to save them in one pdf file

thanks

[TMS]

You would probably need to copy both ranges to a temporary sheet and save that as a .pdf file.

Record a macro while you carry out the actions manually.

[mena]

thank you TMS

[TMS]

You're welcome. Thanks for the rep.

[jolivanes]

If you need it in one sheet, above should be the solution.
If, as you state in your post, you need it in one file, no need to copy and paste.

Please Login or Register  to view this content.