How to add a company tagline (logo) on the row after the last row of a pivot table

I have a pivot table report based on a dynamic named range & allows user to expand row labels to view data. The default setting that the reports will be send out spans over approximately 50 rows but with the expanded data , it could be well over 150 rows.
My company prefers to use a template to generate all reports and the company tagline which contains 3 words, is to be placed on all reports on the right bottom corner of the visible worksheet.
My problem is there's no saying how many rows of data a user might choose to expand to, I can't decide where to place this tagline.Any suggestions on how I can deal with the problem?

Hi, thanks for that. The pivot table expands horizontally too, so pasting it to the right isn't an option either.

I can organise for the users to enable macros, but I don't have much exposure to macros & don't know where to start.

Brilliant, it worked! Thanks heaps.All i now need to do is format the tagline in the code and add the version no. on the bottom left of the table. I'll keep you posted.

Hi Donkeyote,

The macro runs fine when there's only a few words in the tagline just like 'Merry Christmas" in your example. However, I also need to add the version of the report on the bottom left of the pivot table , (same row as the tagline) . e.g.Version 1.a and then |Very|Merry|Christmas on the right hand bottom. The 'Version1.a' is to be in Tahoma - 10 Regular & '|Very|Merry|Christmas' has to be Tahoma 10 , Bold.I thought I could tweak your code to suit this, but couldn't quite manage to get the results I expected.

Hopefully you're able to help out with this.