adding worksheets

[macker]

Hi

I've used a piece of software to convert a pdf file to excel. Unfortunately it's put each page of the pdf file onto a separate worksheet. Is there any way, apart from cutting & pasting, I can combine all the worksheets into one?

 

[VoG]

This may help http://msdn.microsoft.com/en-us/library/cc793964.aspx

 

[macker]

Thanks, I'd seen that article,but I'd prefer a function that could do it, as I've never used code.