Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime 1004 error when insert.
This is the problematic code. It only gives the error when in shared mode. i think it may need a "Xl" somewhere??? Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range) Application.EnableEvents = False Application.ScreenUpdating = False If Target.Column = 2 And Target.Column <= 10 And Target.Row = 5 And Target.Row <= 9 Then Set ws1 = Worksheets(1) For x = 10 To 19 score = ws1.Cells(x, 12).Value scoreRow = x For y = x + 1 To 19 If ws1.Cells(y, 12).Value score Then score = ws1.Cells(y, 12).Value scoreRow = y End If Next y If scoreRow < x Then ws1.Cells(scoreRow, 11).Cut ws1.Cells(x, 11).Insert ws1.Cells(scoreRow, 12).Cut ws1.Cells(x, 12).Insert End If Next x End If ThisWorkbook.Save Application.ScreenUpdating = True Application.EnableEvents = True end sub. any help would be great. PS; i do use shared mode. -- mikewild2000 ------------------------------------------------------------------------ mikewild2000's Profile: http://www.excelforum.com/member.php...fo&userid=3276 View this thread: http://www.excelforum.com/showthread...hreadid=520245 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime 1004 error when insert.
Check Help about "Features that are unavailable in shared workbooks". There
is a list of 20 or so things and "Insert or delete blocks of cells" is one of them. One allowable workaround would be to insert/delete an entire row, but I can't tell if that is appropriate in your situation. HTH, -- George Nicholson Remove 'Junk' from return address. "mikewild2000" wrote in message news:mikewild2000.24d8bo_1141845906.3235@excelforu m-nospam.com... This is the problematic code. It only gives the error when in shared mode. i think it may need a "Xl" somewhere??? Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Excel.Range) Application.EnableEvents = False Application.ScreenUpdating = False If Target.Column = 2 And Target.Column <= 10 And Target.Row = 5 And Target.Row <= 9 Then Set ws1 = Worksheets(1) For x = 10 To 19 score = ws1.Cells(x, 12).Value scoreRow = x For y = x + 1 To 19 If ws1.Cells(y, 12).Value score Then score = ws1.Cells(y, 12).Value scoreRow = y End If Next y If scoreRow < x Then ws1.Cells(scoreRow, 11).Cut ws1.Cells(x, 11).Insert ws1.Cells(scoreRow, 12).Cut ws1.Cells(x, 12).Insert End If Next x End If ThisWorkbook.Save Application.ScreenUpdating = True Application.EnableEvents = True end sub. any help would be great. PS; i do use shared mode. -- mikewild2000 ------------------------------------------------------------------------ mikewild2000's Profile: http://www.excelforum.com/member.php...fo&userid=3276 View this thread: http://www.excelforum.com/showthread...hreadid=520245 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime 1004 error when insert.
SCORE BOARD What it is doing is: i have i col of 10 team names (team 1, team 2, etc) from K10 to K19 Then from L10 to L19 i have the team scores. What the code is doing. It is tying to gether the team name cells with with cell holding it's score (K10 & L10, K11 & L11, etc) Then it is sorting the highest score to the top of the list but keeping the team names in place with the correct score. -- mikewild2000 ------------------------------------------------------------------------ mikewild2000's Profile: http://www.excelforum.com/member.php...fo&userid=3276 View this thread: http://www.excelforum.com/showthread...hreadid=520245 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
Runtime 1004 error when insert. | Excel Programming | |||
Runtime Error 1004??? | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Runtime error 1004 | Excel Programming |