Solved: Can I 'pull in' a worksheet

[Lester]

Hi
Sorry for the inconvenience, everyone...I had marked this thread as solved, but it isn't quite fixed yet (and I don't know how to unset it)

Can anyone take a look at it and help me solve the 'run-time error' I am seeing?

Many thanks
Lester

[Brandtrock]

If the worksheet you are moving out of the workbook is the ONLY worksheet in the workbook, you will get the error described in the original thread.

You could:

1. Copy the worksheet from one file to the next.
   1. Leaving the original file in tact.
   2. Deleting the original file after the copy.
2. Move the worksheet from one file to the next.
   1. Inserting a blank sheet so the desired sheet can be moved.

Regards,

[Lester]

@Brandtrock...fantastic...I added a blank sheet to the file to be copied across and now it works fine.

Cheers
Lester

[Brandtrock]

Glad it worked out for you.

[Lester]

SOLVED.