Hi,

I'm new to Macro, so most of the codes that you may provide may not be
comprehendable by me. In which case, i shall use the code as you provide.

What i need :

1) i have 3 pieces of information on a single worksheet, it's called "Sheet1"
range a15 : b25 .... i call it range 1
range a115 : b125 .... i call it range 2
range a215 : b225 .... i call it range 3

2) On the top of the page, i have put 3 command buttons, for each range,
namely,
"print range 1 to pdf", "print range 2 to pdf", "print range 3 to pdf".

3) The driver that i use to print to PDF is AMYUNI print driver.

4) If i click command button "Print range 1 to pdf", it should
i) print the range a15 : b25 using the Amyuni pdf print driver, row 15
(cells a & B are merged) contains text. use the text in row 15 as the
filename. the pdf document should be saved in a folder called "My work
folder" within My documents. Address is

C:\Documents and Settings\abcdef\My Documents\My Work Folder

Likewise the same procedure should be followed for the other 2 data ranges.

Please do let me know if you require any more information.

Appreciate your help.