LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alternative copy/delete method needed KevHardy Excel Discussion (Misc queries) 2 February 11th 10 01:39 PM
Copy-Paste Alternative Needed... Turp Excel Discussion (Misc queries) 1 January 12th 10 07:03 PM
formula copy or alternative solutions Arain Excel Discussion (Misc queries) 5 August 5th 08 05:33 AM
Alternative to Copy and paste values in VBA thisguy[_2_] Excel Programming 9 August 12th 05 05:00 PM
is there a better alternative to Copy/Paste? MichaelC Excel Programming 3 June 9th 05 12:31 AM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"