PDA

View Full Version : Solved: Can I 'pull in' a worksheet



Lester
11-01-2007, 02:42 AM
Hi
Sorry for the inconvenience, everyone...I had marked this thread (http://vbaexpress.com/forum/showthread.php?t=15848) 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
11-01-2007, 02:54 AM
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:


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

Lester
11-01-2007, 03:02 AM
@Brandtrock...fantastic...I added a blank sheet to the file to be copied across and now it works fine.

Cheers
Lester

Brandtrock
11-01-2007, 03:06 AM
Glad it worked out for you.

Lester
11-01-2007, 04:20 AM
SOLVED.