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 Before:=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 Before:=Sheets(1) - as I am sure this is causing the problem.

Many thanks

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" <(E-Mail Removed)> wrote in message
news:%23c3m$$(E-Mail Removed)...
> 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 Before:=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 Before:=Sheets(1) - as I am sure this is causing the problem.
>
> Many thanks
>
>

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 Before:=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 Before:=Sheets(1) - as I am sure this is causing the problem.
>
> Many thanks
>
>
>

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" <(E-Mail Removed)> wrote in message
> news:%23c3m$$(E-Mail Removed)...
> > 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 Before:=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 Before:=Sheets(1) - as I am sure this is causing the problem.
> >
> > Many thanks
> >
> >
>
>
>

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 Before:=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 Before:=Sheets(1) - as I am sure this is causing the problem.
>
> Many thanks
>
>
>

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" <(E-Mail Removed)> wrote in message
news:3445CAD6-111E-4C94-8A0C-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:%23c3m$$(E-Mail Removed)...
>> > 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 Before:=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 Before:=Sheets(1) - as I am sure this is causing the problem.
>> >
>> > Many thanks
>> >
>> >
>>
>>
>>