Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good afternoon --
The code below has run fine for months and months, and suddenly errors out. The offending line appears to be the Range("AddNewData").Select line, which gives the following error: Method 'Range' of object '_Global' failed Here's the code: Sub AddNewDataPoint() ' ' AddNewDataPoint Macro ' Macro recorded 5/9/2005 by Peter D Berger ' ' 'Unprotect sheet ActiveSheet.Unprotect ("MedMan") Range("AddNewData").Select ' HERE'S THE SPOT! Selection.Copy ActiveWindow.LargeScroll Down:=-1 Range("A6").Select ActiveSheet.Paste ActiveWindow.SmallScroll Down:=28 Rows("53:53").Select Selection.ClearContents Range("A53:D53").Select Selection.Copy Range("A53").Select ActiveSheet.Paste It goes on from there, but I don't think that contributes. The code was written on Excel 2003, and is routinely used now by machines with Excel07. Any help would be greatly appreciated. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Run Time 1004 Error: Application or Object Difine Error | Excel Programming | |||
Run-time error 1004 - General ODBC Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |