Copying worksheets

Resolved · Medium Priority · Version 2003

Mon 8 Sep 2008, 16:37 Delegate Tally said...

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?

Thu 11 Sep 2008, 11:15 Trainer Carlos said...

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

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips

Copying worksheets

Copying worksheets

RE: Copying worksheets

Excel articles

Excel tip:

Find cells that match a format