Hi,

As a long term reader of this site - I'm always amazed with the solutions offered here and so I lay a challenge down to you all..

I have a template spreadsheet with text boxes referenced to cell contents (=$D$4 for instance), a macro then takes my template (approx 100 lines) and copies it out across different files and expands it to 3000+ lines in some cases. My problem is that the text boxes rely on absolute cell referencing to display anything but as the template is copied I need the reference to adjust as any formula would.

Anyone any ideas?

Unfortunately I cannot use a cell to display the information as the formatting will not allow the length of information to be displayed..

Any help would really be appreciated.

Thanks,

Johndinho