Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternative copy/delete method needed | Excel Discussion (Misc queries) | |||
Copy-Paste Alternative Needed... | Excel Discussion (Misc queries) | |||
formula copy or alternative solutions | Excel Discussion (Misc queries) | |||
Alternative to Copy and paste values in VBA | Excel Programming | |||
is there a better alternative to Copy/Paste? | Excel Programming |