Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro crashes excell from remote location
I have a macro that runs fine except when I connect to my computer at
home via "Gotomypc.com" If I run the macro from home it crashes excel. Gives me an error message that cell range could not be read and exel.exe will close. All my other macro's run fine from home. Any Idea what could cause this? Or how to clean up the code? The code is: Sub Assembly_Schedule_Builder() ' ' Assembly_Schedule_Builder Macro ' Macro recorded 6/23/2004 by SCHEDULING ' ' Range("U1").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToLeft)).Select Selection.Copy Workbooks.Add Range("A1").Select ActiveSheet.Paste Application.CutCopyMode = False Range("C:C,F:F").Select Range("F1").Activate Selection.Insert Shift:=xlToRight Range("C1").Select ActiveCell.FormulaR1C1 = _ "=IF(LEFT(RC[1],5)=""HERTZ"",""HERTZ"",IF(LEFT(RC[1],5)=""DOANE"",""TERA"",""K""))" Range("D1").Select Selection.End(xlDown).Select Range("C70").Select Range(Selection, Selection.End(xlUp)).Select Selection.FillDown Selection.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ActiveWindow.SmallScroll Down:=-36 Range("D1").Select Application.CutCopyMode = False Range("G1").Select ActiveCell.FormulaR1C1 = _ "=IF(LEFT(RC[1],5)=""ROADR"",""RDR"",IF(LEFT(RC[1],5)=""ROADW"",""RWY"",LEFT(RC[1],3)))" Range("A1").Select Selection.End(xlDown).Select Range("G70").Select Range(Selection, Selection.End(xlUp)).Select Selection.FillDown Selection.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False ActiveWindow.SmallScroll Down:=-39 Range("D:D,E:E,H:H").Select Range("H1").Activate Application.CutCopyMode = False Selection.Delete Shift:=xlToLeft Columns("N:N").Select Selection.Cut Columns("K:K").Select Selection.Insert Shift:=xlToRight Range("B2").Select Range("B2:L2").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Workbooks.Add Template:= _ "C:\Documents and Settings\SCHEDULING\Application Data\Microsoft\Templates\MASTER.XLT" Range("B3").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Range("B3").Select ActiveSheet.DisplayAutomaticPageBreaks = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Macro location?? | Excel Discussion (Misc queries) | |||
Macro Storage Location | Excel Discussion (Misc queries) | |||
how to set macro using cell location | Excel Programming | |||
macro crashes excell xp | Excel Programming |