Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearArrows - Runtime Error 1004
How to check worksheet contents of Arrow? if yes, the start to clear
Arrows (Auditing Arrows) ? loSheet.ClearArrows '~~ <-- If worksheet without Arrows, will case runtime error 1004. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearArrows - Runtime Error 1004
Using XL2000 & 2002, if I have no arrows showing, calling ClearArrows causes
no error. Maybe the problem is with the WS reference. NickHK "moonhk" wrote in message ps.com... How to check worksheet contents of Arrow? if yes, the start to clear Arrows (Auditing Arrows) ? loSheet.ClearArrows '~~ <-- If worksheet without Arrows, will case runtime error 1004. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearArrows - Runtime Error 1004
Hi NickHK
I am using Excel 2000 SP3. The WS reference is correct. the part of coding as below. Just add On Error Resume Next and On Error GoTo 0 On Error Resume Next loSheet.ClearArrows On Error GoTo 0 For Each cell In loSheet.Range(site.s1dnAddr & "3:" & site.s1dnAddr & SubTotal.getMember_cnt + 3) If cell.Value < TmpStr Then Debug.Print "Build_Summary " & cell.Value & " TmpStr=" & TmpStr & " R1=" & str(R1) & " R2=" & str(R2) '~~MsgBox cell.Value + " " + TmpStr & "R1=" & Str(R1) & " R2=" & R2 '~~ Build Sum formula If (R2 R1) Or (R1 - 1 = R2) Or (R1 = R2) Then If R1 - 1 = R2 Then R2 = R1 End If NickHK wrote: Using XL2000 & 2002, if I have no arrows showing, calling ClearArrows causes no error. Maybe the problem is with the WS reference. NickHK "moonhk" wrote in message ps.com... How to check worksheet contents of Arrow? if yes, the start to clear Arrows (Auditing Arrows) ? loSheet.ClearArrows '~~ <-- If worksheet without Arrows, will case runtime error 1004. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearArrows - Runtime Error 1004
Does this error for you, it doesn't for me
Sub test() Dim ws As Worksheet Set ws = ActiveWorkbook.Worksheets.Add ws.ClearArrows End Sub Regards, Peter T "moonhk" wrote in message oups.com... Hi NickHK I am using Excel 2000 SP3. The WS reference is correct. the part of coding as below. Just add On Error Resume Next and On Error GoTo 0 On Error Resume Next loSheet.ClearArrows On Error GoTo 0 For Each cell In loSheet.Range(site.s1dnAddr & "3:" & site.s1dnAddr & SubTotal.getMember_cnt + 3) If cell.Value < TmpStr Then Debug.Print "Build_Summary " & cell.Value & " TmpStr=" & TmpStr & " R1=" & str(R1) & " R2=" & str(R2) '~~MsgBox cell.Value + " " + TmpStr & "R1=" & Str(R1) & " R2=" & R2 '~~ Build Sum formula If (R2 R1) Or (R1 - 1 = R2) Or (R1 = R2) Then If R1 - 1 = R2 Then R2 = R1 End If NickHK wrote: Using XL2000 & 2002, if I have no arrows showing, calling ClearArrows causes no error. Maybe the problem is with the WS reference. NickHK "moonhk" wrote in message ps.com... How to check worksheet contents of Arrow? if yes, the start to clear Arrows (Auditing Arrows) ? loSheet.ClearArrows '~~ <-- If worksheet without Arrows, will case runtime error 1004. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearArrows - Runtime Error 1004
Peter,
I can't get .ClearArrows to error at all. That's why I was surprised with the OP's problem. NickHK "Peter T" <peter_t@discussions wrote in message ... Does this error for you, it doesn't for me Sub test() Dim ws As Worksheet Set ws = ActiveWorkbook.Worksheets.Add ws.ClearArrows End Sub Regards, Peter T "moonhk" wrote in message oups.com... Hi NickHK I am using Excel 2000 SP3. The WS reference is correct. the part of coding as below. Just add On Error Resume Next and On Error GoTo 0 On Error Resume Next loSheet.ClearArrows On Error GoTo 0 For Each cell In loSheet.Range(site.s1dnAddr & "3:" & site.s1dnAddr & SubTotal.getMember_cnt + 3) If cell.Value < TmpStr Then Debug.Print "Build_Summary " & cell.Value & " TmpStr=" & TmpStr & " R1=" & str(R1) & " R2=" & str(R2) '~~MsgBox cell.Value + " " + TmpStr & "R1=" & Str(R1) & " R2=" & R2 '~~ Build Sum formula If (R2 R1) Or (R1 - 1 = R2) Or (R1 = R2) Then If R1 - 1 = R2 Then R2 = R1 End If NickHK wrote: Using XL2000 & 2002, if I have no arrows showing, calling ClearArrows causes no error. Maybe the problem is with the WS reference. NickHK "moonhk" wrote in message ps.com... How to check worksheet contents of Arrow? if yes, the start to clear Arrows (Auditing Arrows) ? loSheet.ClearArrows '~~ <-- If worksheet without Arrows, will case runtime error 1004. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearArrows - Runtime Error 1004
Hi Both
Today, rerun the coding. no error found. NickHK wrote: Peter, I can't get .ClearArrows to error at all. That's why I was surprised with the OP's problem. NickHK "Peter T" <peter_t@discussions wrote in message ... Does this error for you, it doesn't for me Sub test() Dim ws As Worksheet Set ws = ActiveWorkbook.Worksheets.Add ws.ClearArrows End Sub Regards, Peter T "moonhk" wrote in message oups.com... Hi NickHK I am using Excel 2000 SP3. The WS reference is correct. the part of coding as below. Just add On Error Resume Next and On Error GoTo 0 On Error Resume Next loSheet.ClearArrows On Error GoTo 0 For Each cell In loSheet.Range(site.s1dnAddr & "3:" & site.s1dnAddr & SubTotal.getMember_cnt + 3) If cell.Value < TmpStr Then Debug.Print "Build_Summary " & cell.Value & " TmpStr=" & TmpStr & " R1=" & str(R1) & " R2=" & str(R2) '~~MsgBox cell.Value + " " + TmpStr & "R1=" & Str(R1) & " R2=" & R2 '~~ Build Sum formula If (R2 R1) Or (R1 - 1 = R2) Or (R1 = R2) Then If R1 - 1 = R2 Then R2 = R1 End If NickHK wrote: Using XL2000 & 2002, if I have no arrows showing, calling ClearArrows causes no error. Maybe the problem is with the WS reference. NickHK "moonhk" wrote in message ps.com... How to check worksheet contents of Arrow? if yes, the start to clear Arrows (Auditing Arrows) ? loSheet.ClearArrows '~~ <-- If worksheet without Arrows, will case runtime error 1004. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime 1004 error | Excel Programming | |||
runtime error '1004' | Excel Discussion (Misc queries) | |||
Runtime error 1004 | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Why I got this 1004 runtime error | Excel Programming |