Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with copying worksheet (excel 97 vs excel 2000)
Hi It got the following code Code: -------------------- Sub viewtables() ' Sheets("menu").Range("h3").Value = 1 Sheets("Tables(MAIN)").Copy after:=Sheets(Sheets.Count) Sheets("Tables(MAIN) (2)").Select Sheets("Tables(MAIN) (2)").Name = "Tables" findshapes Range("d1").Value = "" Range("A1").Select Sheets("menu").Range("h3").Value = "" -------------------- If works perfect on my machine which has excel 2000 however if I go to a machien with 97 on it comes up with the following error Runtime Error 1004 copy method of worksheet class failed. And breaks at the "sheets.copy after " part. Any idea why as I have recorded a macro on excel 97 and it come out with exactly the same lines. -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=545021 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting of charts changes when copying from excel 2000 to 200. | Charts and Charting in Excel | |||
Excel 2000 problem copying drawingobjects between sheets | Excel Discussion (Misc queries) | |||
Copying subtotals in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 filling/copying | Setting up and Configuration of Excel | |||
Copying an array to a worksheet: Excel 97 vs 2000 | Excel Programming |