saving excel worksheet to a PDF file

Hi

I am getting mysel into a bit of a fluster trying to convert individual pages on a worksheet to a PDF file , is it possible to convert the individual pages in a worksheet to individual pdf files instead of converting the whole worksheet to pdf?

thanks
baz