Alternative VBA to copy a worksheet

[Graham Whitehead]

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

 

[Bob Phillips]

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)

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Bob Phillips]

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)