Tally has attended:
Excel VBA Intro Intermediate course
Copying worksheets
A macro that copies worksheets from the existing book into a new book which should always be Book1.xls without saving it to any drive. Cells with over x amount of text cannot be copied over and which means you then need to copy them individually. Can this be done in a complete macro without having to copy the individual cells which exceed the limit?
RE: Copying worksheets
Hi Tally
I discussed this with my colleague Stephen and we both feel we need to look at the code and offending worksheet to see if we can solve it
Could you send the workbook with the code to
forum AT stl-training.co.uk
for the Attenton of Stephen Williams (as I'll be away for the next 2 weeks)
I understand that the workbook has important data on it but if you could create a new copy and remove all the important references (So in a table replace client names with Client1 etc), but leave in the long text strings on the legal pages, we will try and see what is causing it.
Regards
Carlos
