Alternative VBA to copy a worksheet
 

Hi,

I am having some problems with some code I wrote a while back which has, up
unitl now, worked fine. The line is:

Sheets("Year to Date").Copy Befo=Sheets(1)

if there a generic way to copy a worksheet and move it to the first
posistion, i.e. the worksheet foremost to the left, without having to
specifiy Befo=Sheets(1) - as I am sure this is causing the problem.

Many thanks

Alternative VBA to copy a worksheet
 

That's the only way. Before should not cause you a problem. Maybe there is
something in the code causing it.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Graham Whitehead" wrote in message
...
Hi,

I am having some problems with some code I wrote a while back which has,
up
unitl now, worked fine. The line is:

Sheets("Year to Date").Copy Befo=Sheets(1)

if there a generic way to copy a worksheet and move it to the first
posistion, i.e. the worksheet foremost to the left, without having to
specifiy Befo=Sheets(1) - as I am sure this is causing the problem.

Many thanks

Alternative VBA to copy a worksheet
 

This is an excerpt from VBA help on copying sheets.

If you don't specify either Before or After, Microsoft Excel creates a new
workbook that contains the copied sheet.

So it looks like you have to specify where you want it if you want it in the
same workbook. If you are having problems with that syntax, try using the
sheet name instead of the index number.

"Graham Whitehead" wrote:

Hi,

I am having some problems with some code I wrote a while back which has, up
unitl now, worked fine. The line is:

Sheets("Year to Date").Copy Befo=Sheets(1)

if there a generic way to copy a worksheet and move it to the first
posistion, i.e. the worksheet foremost to the left, without having to
specifiy Befo=Sheets(1) - as I am sure this is causing the problem.

Many thanks

Alternative VBA to copy a worksheet
 

If you don't include the Befrroe or After excel puts the new worksheet in a
new wrokbook. I don't think that is what you want.

"Bob Phillips" wrote:

That's the only way. Before should not cause you a problem. Maybe there is
something in the code causing it.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Graham Whitehead" wrote in message
...
Hi,

I am having some problems with some code I wrote a while back which has,
up
unitl now, worked fine. The line is:

Sheets("Year to Date").Copy Befo=Sheets(1)

if there a generic way to copy a worksheet and move it to the first
posistion, i.e. the worksheet foremost to the left, without having to
specifiy Befo=Sheets(1) - as I am sure this is causing the problem.

Many thanks

Alternative VBA to copy a worksheet
 

When you look in the VBAProject is there a Sheet1(TabName) or Sheet*(Sheet1).
It could be someone deleted the worksheet you code is referring to.
--
Mike Q.


"Graham Whitehead" wrote:

Hi,

I am having some problems with some code I wrote a while back which has, up
unitl now, worked fine. The line is:

Sheets("Year to Date").Copy Befo=Sheets(1)

if there a generic way to copy a worksheet and move it to the first
posistion, i.e. the worksheet foremost to the left, without having to
specifiy Befo=Sheets(1) - as I am sure this is causing the problem.

Many thanks

Alternative VBA to copy a worksheet
 

But he did use Before? And the whole point of the question was to ask if he
could achieve that result some other way.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Joel" wrote in message
...
If you don't include the Befrroe or After excel puts the new worksheet in
a
new wrokbook. I don't think that is what you want.

"Bob Phillips" wrote:

That's the only way. Before should not cause you a problem. Maybe there
is
something in the code causing it.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Graham Whitehead" wrote in message
...
Hi,

I am having some problems with some code I wrote a while back which
has,
up
unitl now, worked fine. The line is:

Sheets("Year to Date").Copy Befo=Sheets(1)

if there a generic way to copy a worksheet and move it to the first
posistion, i.e. the worksheet foremost to the left, without having to
specifiy Befo=Sheets(1) - as I am sure this is causing the problem.

Many thanks