Is it possible to use VBA to insert a title into a pivot table?

I've been playing around with VBA, getting it to automatically generate pivot tables based on data from an imported .csv file.
Now, rather than just type text into cells above a pivot table to give it a 'title', is it possible, for example, to find the start and end date in a column [Column B] and then insert a text box at the top of the pivot table with some text in along the lines of "Report XYZ from " [start date] "to" [end date] using a VBA solution?

Thks