Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple Macro, works in Excel 2002, 2003 but won't work in 2000
Hello all,
I am relatively new to recording macros in excel, and I have problem that's stumped me. I have two sheets in a workbook and I'm trying to copy the data from one sheet and paste it to the other. Here is the relevant portion of my code: Sheets("Occ. Summary").Select Range("I7").Select Selection.Copy Sheets("All Weeks").Select Range("A3").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False It works fine in excel 2003 and 2002, but when it's run in excel 2000, I get a runtime 1004 error - paste special method of range class failed at the "Selection.PasteSpecial" line. Unfortunately, I can't just have the employees who use 2000 upgrade to 2003 (although they probably should), that isn't my decision. Any ideas on how to modify this code so it will work in 2000? Thanks in advance, Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code works in Excel 2003 but won't work in Excel 2000 | Excel Programming | |||
VBA Code works in Excel 2003 but won't work in Excel 2000 | Excel Programming | |||
sendmail works in excel 2002 but not 2000 | Excel Programming | |||
Excel 2000 VBA App Now Works in Excel 2003, but not Excel 2002 | Excel Programming | |||
Hide Row macro works in 2002 but not 2003 | Excel Programming |