'Range' of object '_Global' failed ---runtime error 1004

xiahuagreen · Oct 19, 2019

Hello
below is my code, it works only 1/3 of the upper screen as expected, error msg comes out anywhere else. please help to identify the root cause. Thanks so much.

Sub FindMax()
'
Dim zoomCell As Range, zoomRng As Range, maxCell As Variant

ActiveSheet.Cells.Interior.Color = xlNone 'Clear out old highlight colors first

If Selection.Cells.Count = 1 Then
MsgBox "You must select a range before pressing button - Try again"
End
End If

Set zoomRng = Application.Selection
Selection.Name = "zoomArea"

For Each zoomCell In Range(zoomRng.Address)
zoomCell.Cells.Interior.ColorIndex = 6 'Yellow highlight selected cells.
Next zoomCell

maxCell = WorksheetFunction.Max(Range(zoomRng.Address)) 'obtain address for each cell

With ActiveSheet.Range(zoomRng.Address)
Set c = .Find(maxCell, LookIn:=xlValues) 'find the max value cell
If Not c Is Nothing Then
maxaddress = c.Address 'Find max value in select cells.
End If
End With

ActiveWindow.Zoom = True

Range(maxaddress).Cells.Interior.ColorIndex = 22 'Red highlight for Max value. <<<<<<<<<<<<< This line is in error when debug

MsgBox "Max value = " & maxCell & " at cell " & maxaddress

ActiveWindow.Zoom = 70

maxaddress = Clear
maxCell = Clear
zoomCell = Clear
End Sub

Fluff · Oct 19, 2019

Hi & welcome to MrExcel.
How about

Code:

Sub FindMax()
'
Dim MaxCell As Range, zoomRng As Range, maxvalue As Variant

ActiveSheet.Cells.Interior.Color = xlNone 'Clear out old highlight colors first

If Selection.Cells.Count = 1 Then
    MsgBox "You must select a range before pressing button - Try again"
    Exit Sub
End If

Set zoomRng = Application.Selection
Selection.Name = "zoomArea"


zoomRng.Interior.ColorIndex = 6 'Yellow highlight selected cells.

maxvalue = WorksheetFunction.Max(zoomRng) 'obtain address for each cell


Set MaxCell = zoomRng.Find(maxvalue, LookIn:=xlValues) 'find the max value cell
If Not MaxCell Is Nothing Then
    ActiveWindow.Zoom = True
    MaxCell.Interior.ColorIndex = 22

    MsgBox "Max value = " & maxvalue & " at cell " & MaxCell.Address

    ActiveWindow.Zoom = 70
Else
    MsgBox "No Max value found"
End If
End Sub

xiahuagreen · Oct 19, 2019

Fluff said:

Hi & welcome to MrExcel.
How about

Code:

Sub FindMax()
'
Dim MaxCell As Range, zoomRng As Range, maxvalue As Variant

ActiveSheet.Cells.Interior.Color = xlNone 'Clear out old highlight colors first

If Selection.Cells.Count = 1 Then
    MsgBox "You must select a range before pressing button - Try again"
    Exit Sub
End If

Set zoomRng = Application.Selection
Selection.Name = "zoomArea"


zoomRng.Interior.ColorIndex = 6 'Yellow highlight selected cells.

maxvalue = WorksheetFunction.Max(zoomRng) 'obtain address for each cell


Set MaxCell = zoomRng.Find(maxvalue, LookIn:=xlValues) 'find the max value cell
If Not MaxCell Is Nothing Then
    ActiveWindow.Zoom = True
    MaxCell.Interior.ColorIndex = 22

    MsgBox "Max value = " & maxvalue & " at cell " & MaxCell.Address

    ActiveWindow.Zoom = 70
Else
    MsgBox "No Max value found"
End If
End Sub

Hi thanks for the help. I applied your routine and this time the error msg: Compile error: Ambiguous name detected: FindMax
am I getting into more trouble this time?

Fluff · Oct 19, 2019

You need to delete your original macro, or change the name of one of them.

xiahuagreen · Oct 19, 2019

xiahuagreen said:
Hi thanks for the help. I applied your routine and this time the error msg: Compile error: Ambiguous name detected: FindMax
am I getting into more trouble this time?

Hi, I tried this set of code and it only gave me the message "no max value found"
I am using the below set of data, hope it's not occupying too much space here...
[TABLE="width: 1302"]
<colgroup><col width="62" span="21" style="width:47pt"> </colgroup><tbody>[TR]
[TD="width: 62, align: right"]12[/TD]
[TD="width: 62, align: right"]13.14[/TD]
[TD="width: 62, align: right"]14.16[/TD]
[TD="width: 62, align: right"]15.06[/TD]
[TD="width: 62, align: right"]15.84[/TD]
[TD="width: 62, align: right"]16.5[/TD]
[TD="width: 62, align: right"]17.04[/TD]
[TD="width: 62, align: right"]17.46[/TD]
[TD="width: 62, align: right"]17.76[/TD]
[TD="width: 62, align: right"]17.94[/TD]
[TD="width: 62, align: right"]18[/TD]
[TD="width: 62, align: right"]17.94[/TD]
[TD="width: 62, align: right"]17.76[/TD]
[TD="width: 62, align: right"]17.46[/TD]
[TD="width: 62, align: right"]17.04[/TD]
[TD="width: 62, align: right"]16.5[/TD]
[TD="width: 62, align: right"]15.84[/TD]
[TD="width: 62, align: right"]15.06[/TD]
[TD="width: 62, align: right"]14.16[/TD]
[TD="width: 62, align: right"]13.14[/TD]
[TD="width: 62, align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]12.4449[/TD]
[TD="align: right"]13.5949[/TD]
[TD="align: right"]14.6249[/TD]
[TD="align: right"]15.5349[/TD]
[TD="align: right"]16.3249[/TD]
[TD="align: right"]16.9949[/TD]
[TD="align: right"]17.5449[/TD]
[TD="align: right"]17.9749[/TD]
[TD="align: right"]18.2849[/TD]
[TD="align: right"]18.4749[/TD]
[TD="align: right"]18.5449[/TD]
[TD="align: right"]18.4949[/TD]
[TD="align: right"]18.3249[/TD]
[TD="align: right"]18.0349[/TD]
[TD="align: right"]17.6249[/TD]
[TD="align: right"]17.0949[/TD]
[TD="align: right"]16.4449[/TD]
[TD="align: right"]15.6749[/TD]
[TD="align: right"]14.7849[/TD]
[TD="align: right"]13.7749[/TD]
[TD="align: right"]12.6449[/TD]
[/TR]
[TR]
[TD="align: right"]12.9984[/TD]
[TD="align: right"]14.1584[/TD]
[TD="align: right"]15.1984[/TD]
[TD="align: right"]16.1184[/TD]
[TD="align: right"]16.9184[/TD]
[TD="align: right"]17.5984[/TD]
[TD="align: right"]18.1584[/TD]
[TD="align: right"]18.5984[/TD]
[TD="align: right"]18.9184[/TD]
[TD="align: right"]19.1184[/TD]
[TD="align: right"]19.1984[/TD]
[TD="align: right"]19.1584[/TD]
[TD="align: right"]18.9984[/TD]
[TD="align: right"]18.7184[/TD]
[TD="align: right"]18.3184[/TD]
[TD="align: right"]17.7984[/TD]
[TD="align: right"]17.1584[/TD]
[TD="align: right"]16.3984[/TD]
[TD="align: right"]15.5184[/TD]
[TD="align: right"]14.5184[/TD]
[TD="align: right"]13.3984[/TD]
[/TR]
[TR]
[TD="align: right"]13.6869[/TD]
[TD="align: right"]14.8569[/TD]
[TD="align: right"]15.9069[/TD]
[TD="align: right"]16.8369[/TD]
[TD="align: right"]17.6469[/TD]
[TD="align: right"]18.3369[/TD]
[TD="align: right"]18.9069[/TD]
[TD="align: right"]19.3569[/TD]
[TD="align: right"]19.6869[/TD]
[TD="align: right"]19.8969[/TD]
[TD="align: right"]19.9869[/TD]
[TD="align: right"]19.9569[/TD]
[TD="align: right"]19.8069[/TD]
[TD="align: right"]19.5369[/TD]
[TD="align: right"]19.1469[/TD]
[TD="align: right"]18.6369[/TD]
[TD="align: right"]18.0069[/TD]
[TD="align: right"]17.2569[/TD]
[TD="align: right"]16.3869[/TD]
[TD="align: right"]15.3969[/TD]
[TD="align: right"]14.2869[/TD]
[/TR]
[TR]
[TD="align: right"]14.5344[/TD]
[TD="align: right"]15.7144[/TD]
[TD="align: right"]16.7744[/TD]
[TD="align: right"]17.7144[/TD]
[TD="align: right"]18.5344[/TD]
[TD="align: right"]19.2344[/TD]
[TD="align: right"]19.8144[/TD]
[TD="align: right"]20.2744[/TD]
[TD="align: right"]20.6144[/TD]
[TD="align: right"]20.8344[/TD]
[TD="align: right"]20.9344[/TD]
[TD="align: right"]20.9144[/TD]
[TD="align: right"]20.7744[/TD]
[TD="align: right"]20.5144[/TD]
[TD="align: right"]20.1344[/TD]
[TD="align: right"]19.6344[/TD]
[TD="align: right"]19.0144[/TD]
[TD="align: right"]18.2744[/TD]
[TD="align: right"]17.4144[/TD]
[TD="align: right"]16.4344[/TD]
[TD="align: right"]15.3344[/TD]
[/TR]
[TR]
[TD="align: right"]15.5625[/TD]
[TD="align: right"]16.7525[/TD]
[TD="align: right"]17.8225[/TD]
[TD="align: right"]18.7725[/TD]
[TD="align: right"]19.6025[/TD]
[TD="align: right"]20.3125[/TD]
[TD="align: right"]20.9025[/TD]
[TD="align: right"]21.3725[/TD]
[TD="align: right"]21.7225[/TD]
[TD="align: right"]21.9525[/TD]
[TD="align: right"]22.0625[/TD]
[TD="align: right"]22.0525[/TD]
[TD="align: right"]21.9225[/TD]
[TD="align: right"]21.6725[/TD]
[TD="align: right"]21.3025[/TD]
[TD="align: right"]20.8125[/TD]
[TD="align: right"]20.2025[/TD]
[TD="align: right"]19.4725[/TD]
[TD="align: right"]18.6225[/TD]
[TD="align: right"]17.6525[/TD]
[TD="align: right"]16.5625[/TD]
[/TR]
[TR]
[TD="align: right"]16.7904[/TD]
[TD="align: right"]17.9904[/TD]
[TD="align: right"]19.0704[/TD]
[TD="align: right"]20.0304[/TD]
[TD="align: right"]20.8704[/TD]
[TD="align: right"]21.5904[/TD]
[TD="align: right"]22.1904[/TD]
[TD="align: right"]22.6704[/TD]
[TD="align: right"]23.0304[/TD]
[TD="align: right"]23.2704[/TD]
[TD="align: right"]23.3904[/TD]
[TD="align: right"]23.3904[/TD]
[TD="align: right"]23.2704[/TD]
[TD="align: right"]23.0304[/TD]
[TD="align: right"]22.6704[/TD]
[TD="align: right"]22.1904[/TD]
[TD="align: right"]21.5904[/TD]
[TD="align: right"]20.8704[/TD]
[TD="align: right"]20.0304[/TD]
[TD="align: right"]19.0704[/TD]
[TD="align: right"]17.9904[/TD]
[/TR]
[TR]
[TD="align: right"]18.2349[/TD]
[TD="align: right"]19.4449[/TD]
[TD="align: right"]20.5349[/TD]
[TD="align: right"]21.5049[/TD]
[TD="align: right"]22.3549[/TD]
[TD="align: right"]23.0849[/TD]
[TD="align: right"]23.6949[/TD]
[TD="align: right"]24.1849[/TD]
[TD="align: right"]24.5549[/TD]
[TD="align: right"]24.8049[/TD]
[TD="align: right"]24.9349[/TD]
[TD="align: right"]24.9449[/TD]
[TD="align: right"]24.8349[/TD]
[TD="align: right"]24.6049[/TD]
[TD="align: right"]24.2549[/TD]
[TD="align: right"]23.7849[/TD]
[TD="align: right"]23.1949[/TD]
[TD="align: right"]22.4849[/TD]
[TD="align: right"]21.6549[/TD]
[TD="align: right"]20.7049[/TD]
[TD="align: right"]19.6349[/TD]
[/TR]
[TR]
[TD="align: right"]19.9104[/TD]
[TD="align: right"]21.1304[/TD]
[TD="align: right"]22.2304[/TD]
[TD="align: right"]23.2104[/TD]
[TD="align: right"]24.0704[/TD]
[TD="align: right"]24.8104[/TD]
[TD="align: right"]25.4304[/TD]
[TD="align: right"]25.9304[/TD]
[TD="align: right"]26.3104[/TD]
[TD="align: right"]26.5704[/TD]
[TD="align: right"]26.7104[/TD]
[TD="align: right"]26.7304[/TD]
[TD="align: right"]26.6304[/TD]
[TD="align: right"]26.4104[/TD]
[TD="align: right"]26.0704[/TD]
[TD="align: right"]25.6104[/TD]
[TD="align: right"]25.0304[/TD]
[TD="align: right"]24.3304[/TD]
[TD="align: right"]23.5104[/TD]
[TD="align: right"]22.5704[/TD]
[TD="align: right"]21.5104[/TD]
[/TR]
[TR]
[TD="align: right"]21.8289[/TD]
[TD="align: right"]23.0589[/TD]
[TD="align: right"]24.1689[/TD]
[TD="align: right"]25.1589[/TD]
[TD="align: right"]26.0289[/TD]
[TD="align: right"]26.7789[/TD]
[TD="align: right"]27.4089[/TD]
[TD="align: right"]27.9189[/TD]
[TD="align: right"]28.3089[/TD]
[TD="align: right"]28.5789[/TD]
[TD="align: right"]28.7289[/TD]
[TD="align: right"]28.7589[/TD]
[TD="align: right"]28.6689[/TD]
[TD="align: right"]28.4589[/TD]
[TD="align: right"]28.1289[/TD]
[TD="align: right"]27.6789[/TD]
[TD="align: right"]27.1089[/TD]
[TD="align: right"]26.4189[/TD]
[TD="align: right"]25.6089[/TD]
[TD="align: right"]24.6789[/TD]
[TD="align: right"]23.6289[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]25.24[/TD]
[TD="align: right"]26.36[/TD]
[TD="align: right"]27.36[/TD]
[TD="align: right"]28.24[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]29.64[/TD]
[TD="align: right"]30.16[/TD]
[TD="align: right"]30.56[/TD]
[TD="align: right"]30.84[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]31.04[/TD]
[TD="align: right"]30.96[/TD]
[TD="align: right"]30.76[/TD]
[TD="align: right"]30.44[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]29.44[/TD]
[TD="align: right"]28.76[/TD]
[TD="align: right"]27.96[/TD]
[TD="align: right"]27.04[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD="align: right"]26.4309[/TD]
[TD="align: right"]27.6809[/TD]
[TD="align: right"]28.8109[/TD]
[TD="align: right"]29.8209[/TD]
[TD="align: right"]30.7109[/TD]
[TD="align: right"]31.4809[/TD]
[TD="align: right"]32.1309[/TD]
[TD="align: right"]32.6609[/TD]
[TD="align: right"]33.0709[/TD]
[TD="align: right"]33.3609[/TD]
[TD="align: right"]33.5309[/TD]
[TD="align: right"]33.5809[/TD]
[TD="align: right"]33.5109[/TD]
[TD="align: right"]33.3209[/TD]
[TD="align: right"]33.0109[/TD]
[TD="align: right"]32.5809[/TD]
[TD="align: right"]32.0309[/TD]
[TD="align: right"]31.3609[/TD]
[TD="align: right"]30.5709[/TD]
[TD="align: right"]29.6609[/TD]
[TD="align: right"]28.6309[/TD]
[/TR]
[TR]
[TD="align: right"]29.1264[/TD]
[TD="align: right"]30.3864[/TD]
[TD="align: right"]31.5264[/TD]
[TD="align: right"]32.5464[/TD]
[TD="align: right"]33.4464[/TD]
[TD="align: right"]34.2264[/TD]
[TD="align: right"]34.8864[/TD]
[TD="align: right"]35.4264[/TD]
[TD="align: right"]35.8464[/TD]
[TD="align: right"]36.1464[/TD]
[TD="align: right"]36.3264[/TD]
[TD="align: right"]36.3864[/TD]
[TD="align: right"]36.3264[/TD]
[TD="align: right"]36.1464[/TD]
[TD="align: right"]35.8464[/TD]
[TD="align: right"]35.4264[/TD]
[TD="align: right"]34.8864[/TD]
[TD="align: right"]34.2264[/TD]
[TD="align: right"]33.4464[/TD]
[TD="align: right"]32.5464[/TD]
[TD="align: right"]31.5264[/TD]
[/TR]
[TR]
[TD="align: right"]32.0889[/TD]
[TD="align: right"]33.3589[/TD]
[TD="align: right"]34.5089[/TD]
[TD="align: right"]35.5389[/TD]
[TD="align: right"]36.4489[/TD]
[TD="align: right"]37.2389[/TD]
[TD="align: right"]37.9089[/TD]
[TD="align: right"]38.4589[/TD]
[TD="align: right"]38.8889[/TD]
[TD="align: right"]39.1989[/TD]
[TD="align: right"]39.3889[/TD]
[TD="align: right"]39.4589[/TD]
[TD="align: right"]39.4089[/TD]
[TD="align: right"]39.2389[/TD]
[TD="align: right"]38.9489[/TD]
[TD="align: right"]38.5389[/TD]
[TD="align: right"]38.0089[/TD]
[TD="align: right"]37.3589[/TD]
[TD="align: right"]36.5889[/TD]
[TD="align: right"]35.6989[/TD]
[TD="align: right"]34.6889[/TD]
[/TR]
[TR]
[TD="align: right"]35.3184[/TD]
[TD="align: right"]36.5984[/TD]
[TD="align: right"]37.7584[/TD]
[TD="align: right"]38.7984[/TD]
[TD="align: right"]39.7184[/TD]
[TD="align: right"]40.5184[/TD]
[TD="align: right"]41.1984[/TD]
[TD="align: right"]41.7584[/TD]
[TD="align: right"]42.1984[/TD]
[TD="align: right"]42.5184[/TD]
[TD="align: right"]42.7184[/TD]
[TD="align: right"]42.7984[/TD]
[TD="align: right"]42.7584[/TD]
[TD="align: right"]42.5984[/TD]
[TD="align: right"]42.3184[/TD]
[TD="align: right"]41.9184[/TD]
[TD="align: right"]41.3984[/TD]
[TD="align: right"]40.7584[/TD]
[TD="align: right"]39.9984[/TD]
[TD="align: right"]39.1184[/TD]
[TD="align: right"]38.1184[/TD]
[/TR]
[TR]
[TD="align: right"]38.8125[/TD]
[TD="align: right"]40.1025[/TD]
[TD="align: right"]41.2725[/TD]
[TD="align: right"]42.3225[/TD]
[TD="align: right"]43.2525[/TD]
[TD="align: right"]44.0625[/TD]
[TD="align: right"]44.7525[/TD]
[TD="align: right"]45.3225[/TD]
[TD="align: right"]45.7725[/TD]
[TD="align: right"]46.1025[/TD]
[TD="align: right"]46.3125[/TD]
[TD="align: right"]46.4025[/TD]
[TD="align: right"]46.3725[/TD]
[TD="align: right"]46.2225[/TD]
[TD="align: right"]45.9525[/TD]
[TD="align: right"]45.5625[/TD]
[TD="align: right"]45.0525[/TD]
[TD="align: right"]44.4225[/TD]
[TD="align: right"]43.6725[/TD]
[TD="align: right"]42.8025[/TD]
[TD="align: right"]41.8125[/TD]
[/TR]
[TR]
[TD="align: right"]42.5664[/TD]
[TD="align: right"]43.8664[/TD]
[TD="align: right"]45.0464[/TD]
[TD="align: right"]46.1064[/TD]
[TD="align: right"]47.0464[/TD]
[TD="align: right"]47.8664[/TD]
[TD="align: right"]48.5664[/TD]
[TD="align: right"]49.1464[/TD]
[TD="align: right"]49.6064[/TD]
[TD="align: right"]49.9464[/TD]
[TD="align: right"]50.1664[/TD]
[TD="align: right"]50.2664[/TD]
[TD="align: right"]50.2464[/TD]
[TD="align: right"]50.1064[/TD]
[TD="align: right"]49.8464[/TD]
[TD="align: right"]49.4664[/TD]
[TD="align: right"]48.9664[/TD]
[TD="align: right"]48.3464[/TD]
[TD="align: right"]47.6064[/TD]
[TD="align: right"]46.7464[/TD]
[TD="align: right"]45.7664[/TD]
[/TR]
[TR]
[TD="align: right"]46.5729[/TD]
[TD="align: right"]47.8829[/TD]
[TD="align: right"]49.0729[/TD]
[TD="align: right"]50.1429[/TD]
[TD="align: right"]51.0929[/TD]
[TD="align: right"]51.9229[/TD]
[TD="align: right"]52.6329[/TD]
[TD="align: right"]53.2229[/TD]
[TD="align: right"]53.6929[/TD]
[TD="align: right"]54.0429[/TD]
[TD="align: right"]54.2729[/TD]
[TD="align: right"]54.3829[/TD]
[TD="align: right"]54.3729[/TD]
[TD="align: right"]54.2429[/TD]
[TD="align: right"]53.9929[/TD]
[TD="align: right"]53.6229[/TD]
[TD="align: right"]53.1329[/TD]
[TD="align: right"]52.5229[/TD]
[TD="align: right"]51.7929[/TD]
[TD="align: right"]50.9429[/TD]
[TD="align: right"]49.9729[/TD]
[/TR]
[TR]
[TD="align: right"]50.8224[/TD]
[TD="align: right"]52.1424[/TD]
[TD="align: right"]53.3424[/TD]
[TD="align: right"]54.4224[/TD]
[TD="align: right"]55.3824[/TD]
[TD="align: right"]56.2224[/TD]
[TD="align: right"]56.9424[/TD]
[TD="align: right"]57.5424[/TD]
[TD="align: right"]58.0224[/TD]
[TD="align: right"]58.3824[/TD]
[TD="align: right"]58.6224[/TD]
[TD="align: right"]58.7424[/TD]
[TD="align: right"]58.7424[/TD]
[TD="align: right"]58.6224[/TD]
[TD="align: right"]58.3824[/TD]
[TD="align: right"]58.0224[/TD]
[TD="align: right"]57.5424[/TD]
[TD="align: right"]56.9424[/TD]
[TD="align: right"]56.2224[/TD]
[TD="align: right"]55.3824[/TD]
[TD="align: right"]54.4224[/TD]
[/TR]
[TR]
[TD="align: right"]55.3029[/TD]
[TD="align: right"]56.6329[/TD]
[TD="align: right"]57.8429[/TD]
[TD="align: right"]58.9329[/TD]
[TD="align: right"]59.9029[/TD]
[TD="align: right"]60.7529[/TD]
[TD="align: right"]61.4829[/TD]
[TD="align: right"]62.0929[/TD]
[TD="align: right"]62.5829[/TD]
[TD="align: right"]62.9529[/TD]
[TD="align: right"]63.2029[/TD]
[TD="align: right"]63.3329[/TD]
[TD="align: right"]63.3429[/TD]
[TD="align: right"]63.2329[/TD]
[TD="align: right"]63.0029[/TD]
[TD="align: right"]62.6529[/TD]
[TD="align: right"]62.1829[/TD]
[TD="align: right"]61.5929[/TD]
[TD="align: right"]60.8829[/TD]
[TD="align: right"]60.0529[/TD]
[TD="align: right"]59.1029[/TD]
[/TR]
[TR]
[TD="align: right"]60[/TD]
[TD="align: right"]61.34[/TD]
[TD="align: right"]62.56[/TD]
[TD="align: right"]63.66[/TD]
[TD="align: right"]64.64[/TD]
[TD="align: right"]65.5[/TD]
[TD="align: right"]66.24[/TD]
[TD="align: right"]66.86[/TD]
[TD="align: right"]67.36[/TD]
[TD="align: right"]67.74[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]68.14[/TD]
[TD="align: right"]68.16[/TD]
[TD="align: right"]68.06[/TD]
[TD="align: right"]67.84[/TD]
[TD="align: right"]67.5[/TD]
[TD="align: right"]67.04[/TD]
[TD="align: right"]66.46[/TD]
[TD="align: right"]65.76[/TD]
[TD="align: right"]64.94[/TD]
[TD="align: right"]64[/TD]
[/TR]
[TR]
[TD="align: right"]64.8969[/TD]
[TD="align: right"]66.2469[/TD]
[TD="align: right"]67.4769[/TD]
[TD="align: right"]68.5869[/TD]
[TD="align: right"]69.5769[/TD]
[TD="align: right"]70.4469[/TD]
[TD="align: right"]71.1969[/TD]
[TD="align: right"]71.8269[/TD]
[TD="align: right"]72.3369[/TD]
[TD="align: right"]72.7269[/TD]
[TD="align: right"]72.9969[/TD]
[TD="align: right"]73.1469[/TD]
[TD="align: right"]73.1769[/TD]
[TD="align: right"]73.0869[/TD]
[TD="align: right"]72.8769[/TD]
[TD="align: right"]72.5469[/TD]
[TD="align: right"]72.0969[/TD]
[TD="align: right"]71.5269[/TD]
[TD="align: right"]70.8369[/TD]
[TD="align: right"]70.0269[/TD]
[TD="align: right"]69.0969[/TD]
[/TR]
[TR]
[TD="align: right"]69.9744[/TD]
[TD="align: right"]71.3344[/TD]
[TD="align: right"]72.5744[/TD]
[TD="align: right"]73.6944[/TD]
[TD="align: right"]74.6944[/TD]
[TD="align: right"]75.5744[/TD]
[TD="align: right"]76.3344[/TD]
[TD="align: right"]76.9744[/TD]
[TD="align: right"]77.4944[/TD]
[TD="align: right"]77.8944[/TD]
[TD="align: right"]78.1744[/TD]
[TD="align: right"]78.3344[/TD]
[TD="align: right"]78.3744[/TD]
[TD="align: right"]78.2944[/TD]
[TD="align: right"]78.0944[/TD]
[TD="align: right"]77.7744[/TD]
[TD="align: right"]77.3344[/TD]
[TD="align: right"]76.7744[/TD]
[TD="align: right"]76.0944[/TD]
[TD="align: right"]75.2944[/TD]
[TD="align: right"]74.3744[/TD]
[/TR]
[TR]
[TD="align: right"]75.2109[/TD]
[TD="align: right"]76.5809[/TD]
[TD="align: right"]77.8309[/TD]
[TD="align: right"]78.9609[/TD]
[TD="align: right"]79.9709[/TD]
[TD="align: right"]80.8609[/TD]
[TD="align: right"]81.6309[/TD]
[TD="align: right"]82.2809[/TD]
[TD="align: right"]82.8109[/TD]
[TD="align: right"]83.2209[/TD]
[TD="align: right"]83.5109[/TD]
[TD="align: right"]83.6809[/TD]
[TD="align: right"]83.7309[/TD]
[TD="align: right"]83.6609[/TD]
[TD="align: right"]83.4709[/TD]
[TD="align: right"]83.1609[/TD]
[TD="align: right"]82.7309[/TD]
[TD="align: right"]82.1809[/TD]
[TD="align: right"]81.5109[/TD]
[TD="align: right"]80.7209[/TD]
[TD="align: right"]79.8109[/TD]
[/TR]
[TR]
[TD="align: right"]80.5824[/TD]
[TD="align: right"]81.9624[/TD]
[TD="align: right"]83.2224[/TD]
[TD="align: right"]84.3624[/TD]
[TD="align: right"]85.3824[/TD]
[TD="align: right"]86.2824[/TD]
[TD="align: right"]87.0624[/TD]
[TD="align: right"]87.7224[/TD]
[TD="align: right"]88.2624[/TD]
[TD="align: right"]88.6824[/TD]
[TD="align: right"]88.9824[/TD]
[TD="align: right"]89.1624[/TD]
[TD="align: right"]89.2224[/TD]
[TD="align: right"]89.1624[/TD]
[TD="align: right"]88.9824[/TD]
[TD="align: right"]88.6824[/TD]
[TD="align: right"]88.2624[/TD]
[TD="align: right"]87.7224[/TD]
[TD="align: right"]87.0624[/TD]
[TD="align: right"]86.2824[/TD]
[TD="align: right"]85.3824[/TD]
[/TR]
[TR]
[TD="align: right"]86.0625[/TD]
[TD="align: right"]87.4525[/TD]
[TD="align: right"]88.7225[/TD]
[TD="align: right"]89.8725[/TD]
[TD="align: right"]90.9025[/TD]
[TD="align: right"]91.8125[/TD]
[TD="align: right"]92.6025[/TD]
[TD="align: right"]93.2725[/TD]
[TD="align: right"]93.8225[/TD]
[TD="align: right"]94.2525[/TD]
[TD="align: right"]94.5625[/TD]
[TD="align: right"]94.7525[/TD]
[TD="align: right"]94.8225[/TD]
[TD="align: right"]94.7725[/TD]
[TD="align: right"]94.6025[/TD]
[TD="align: right"]94.3125[/TD]
[TD="align: right"]93.9025[/TD]
[TD="align: right"]93.3725[/TD]
[TD="align: right"]92.7225[/TD]
[TD="align: right"]91.9525[/TD]
[TD="align: right"]91.0625[/TD]
[/TR]
[TR]
[TD="align: right"]91.6224[/TD]
[TD="align: right"]93.0224[/TD]
[TD="align: right"]94.3024[/TD]
[TD="align: right"]95.4624[/TD]
[TD="align: right"]96.5024[/TD]
[TD="align: right"]97.4224[/TD]
[TD="align: right"]98.2224[/TD]
[TD="align: right"]98.9024[/TD]
[TD="align: right"]99.4624[/TD]
[TD="align: right"]99.9024[/TD]
[TD="align: right"]100.2224[/TD]
[TD="align: right"]100.4224[/TD]
[TD="align: right"]100.5024[/TD]
[TD="align: right"]100.4624[/TD]
[TD="align: right"]100.3024[/TD]
[TD="align: right"]100.0224[/TD]
[TD="align: right"]99.6224[/TD]
[TD="align: right"]99.1024[/TD]
[TD="align: right"]98.4624[/TD]
[TD="align: right"]97.7024[/TD]
[TD="align: right"]96.8224[/TD]
[/TR]
[TR]
[TD="align: right"]97.2309[/TD]
[TD="align: right"]98.6409[/TD]
[TD="align: right"]99.9309[/TD]
[TD="align: right"]101.1009[/TD]
[TD="align: right"]102.1509[/TD]
[TD="align: right"]103.0809[/TD]
[TD="align: right"]103.8909[/TD]
[TD="align: right"]104.5809[/TD]
[TD="align: right"]105.1509[/TD]
[TD="align: right"]105.6009[/TD]
[TD="align: right"]105.9309[/TD]
[TD="align: right"]106.1409[/TD]
[TD="align: right"]106.2309[/TD]
[TD="align: right"]106.2009[/TD]
[TD="align: right"]106.0509[/TD]
[TD="align: right"]105.7809[/TD]
[TD="align: right"]105.3909[/TD]
[TD="align: right"]104.8809[/TD]
[TD="align: right"]104.2509[/TD]
[TD="align: right"]103.5009[/TD]
[TD="align: right"]102.6309[/TD]
[/TR]
[TR]
[TD="align: right"]102.8544[/TD]
[TD="align: right"]104.2744[/TD]
[TD="align: right"]105.5744[/TD]
[TD="align: right"]106.7544[/TD]
[TD="align: right"]107.8144[/TD]
[TD="align: right"]108.7544[/TD]
[TD="align: right"]109.5744[/TD]
[TD="align: right"]110.2744[/TD]
[TD="align: right"]110.8544[/TD]
[TD="align: right"]111.3144[/TD]
[TD="align: right"]111.6544[/TD]
[TD="align: right"]111.8744[/TD]
[TD="class: xl63, align: right"]111.9744[/TD]
[TD="class: xl63, align: right"]111.9544[/TD]
[TD="class: xl63, align: right"]111.8144[/TD]
[TD="class: xl63, align: right"]111.5544[/TD]
[TD="class: xl63, align: right"]111.1744[/TD]
[TD="class: xl63, align: right"]110.6744[/TD]
[TD="align: right"]110.0544[/TD]
[TD="align: right"]109.3144[/TD]
[TD="align: right"]108.4544[/TD]
[/TR]
[TR]
[TD="align: right"]108.4569[/TD]
[TD="align: right"]109.8869[/TD]
[TD="align: right"]111.1969[/TD]
[TD="align: right"]112.3869[/TD]
[TD="align: right"]113.4569[/TD]
[TD="align: right"]114.4069[/TD]
[TD="align: right"]115.2369[/TD]
[TD="align: right"]115.9469[/TD]
[TD="align: right"]116.5369[/TD]
[TD="align: right"]117.0069[/TD]
[TD="align: right"]117.3569[/TD]
[TD="align: right"]117.5869[/TD]
[TD="class: xl63, align: right"]117.6969[/TD]
[TD="class: xl63, align: right"]117.6869[/TD]
[TD="class: xl63, align: right"]117.5569[/TD]
[TD="class: xl63, align: right"]117.3069[/TD]
[TD="class: xl63, align: right"]116.9369[/TD]
[TD="class: xl63, align: right"]116.4469[/TD]
[TD="align: right"]115.8369[/TD]
[TD="align: right"]115.1069[/TD]
[TD="align: right"]114.2569[/TD]
[/TR]
[TR]
[TD="align: right"]114[/TD]
[TD="align: right"]115.44[/TD]
[TD="align: right"]116.76[/TD]
[TD="align: right"]117.96[/TD]
[TD="align: right"]119.04[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]120.84[/TD]
[TD="align: right"]121.56[/TD]
[TD="align: right"]122.16[/TD]
[TD="align: right"]122.64[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]123.24[/TD]
[TD="class: xl63, align: right"]123.36[/TD]
[TD="class: xl63, align: right"]123.36[/TD]
[TD="class: xl63, align: right"]123.24[/TD]
[TD="class: xl63, align: right"]123[/TD]
[TD="class: xl63, align: right"]122.64[/TD]
[TD="class: xl63, align: right"]122.16[/TD]
[TD="align: right"]121.56[/TD]
[TD="align: right"]120.84[/TD]
[TD="align: right"]120[/TD]
[/TR]
[TR]
[TD="align: right"]119.4429[/TD]
[TD="align: right"]120.8929[/TD]
[TD="align: right"]122.2229[/TD]
[TD="align: right"]123.4329[/TD]
[TD="align: right"]124.5229[/TD]
[TD="align: right"]125.4929[/TD]
[TD="align: right"]126.3429[/TD]
[TD="align: right"]127.0729[/TD]
[TD="align: right"]127.6829[/TD]
[TD="align: right"]128.1729[/TD]
[TD="align: right"]128.5429[/TD]
[TD="align: right"]128.7929[/TD]
[TD="class: xl63, align: right"]128.9229[/TD]
[TD="class: xl63, align: right"]128.9329[/TD]
[TD="class: xl63, align: right"]128.8229[/TD]
[TD="class: xl63, align: right"]128.5929[/TD]
[TD="class: xl63, align: right"]128.2429[/TD]
[TD="class: xl63, align: right"]127.7729[/TD]
[TD="align: right"]127.1829[/TD]
[TD="align: right"]126.4729[/TD]
[TD="align: right"]125.6429[/TD]
[/TR]
[TR]
[TD="align: right"]124.7424[/TD]
[TD="align: right"]126.2024[/TD]
[TD="align: right"]127.5424[/TD]
[TD="align: right"]128.7624[/TD]
[TD="align: right"]129.8624[/TD]
[TD="align: right"]130.8424[/TD]
[TD="align: right"]131.7024[/TD]
[TD="align: right"]132.4424[/TD]
[TD="align: right"]133.0624[/TD]
[TD="align: right"]133.5624[/TD]
[TD="align: right"]133.9424[/TD]
[TD="align: right"]134.2024[/TD]
[TD="class: xl63, align: right"]134.3424[/TD]
[TD="class: xl63, align: right"]134.3624[/TD]
[TD="class: xl63, align: right"]134.2624[/TD]
[TD="class: xl63, align: right"]134.0424[/TD]
[TD="class: xl63, align: right"]133.7024[/TD]
[TD="class: xl63, align: right"]133.2424[/TD]
[TD="align: right"]132.6624[/TD]
[TD="align: right"]131.9624[/TD]
[TD="align: right"]131.1424[/TD]
[/TR]
[TR]
[TD="align: right"]129.8529[/TD]
[TD="align: right"]131.3229[/TD]
[TD="align: right"]132.6729[/TD]
[TD="align: right"]133.9029[/TD]
[TD="align: right"]135.0129[/TD]
[TD="align: right"]136.0029[/TD]
[TD="align: right"]136.8729[/TD]
[TD="align: right"]137.6229[/TD]
[TD="align: right"]138.2529[/TD]
[TD="align: right"]138.7629[/TD]
[TD="align: right"]139.1529[/TD]
[TD="align: right"]139.4229[/TD]
[TD="class: xl63, align: right"]139.5729[/TD]
[TD="class: xl63, align: right"]139.6029[/TD]
[TD="class: xl63, align: right"]139.5129[/TD]
[TD="class: xl63, align: right"]139.3029[/TD]
[TD="class: xl63, align: right"]138.9729[/TD]
[TD="class: xl63, align: right"]138.5229[/TD]
[TD="align: right"]137.9529[/TD]
[TD="align: right"]137.2629[/TD]
[TD="align: right"]136.4529[/TD]
[/TR]
[TR]
[TD="align: right"]134.7264[/TD]
[TD="align: right"]136.2064[/TD]
[TD="align: right"]137.5664[/TD]
[TD="align: right"]138.8064[/TD]
[TD="align: right"]139.9264[/TD]
[TD="align: right"]140.9264[/TD]
[TD="align: right"]141.8064[/TD]
[TD="align: right"]142.5664[/TD]
[TD="align: right"]143.2064[/TD]
[TD="align: right"]143.7264[/TD]
[TD="align: right"]144.1264[/TD]
[TD="align: right"]144.4064[/TD]
[TD="class: xl63, align: right"]144.5664[/TD]
[TD="class: xl63, align: right"]144.6064[/TD]
[TD="class: xl63, align: right"]144.5264[/TD]
[TD="class: xl63, align: right"]144.3264[/TD]
[TD="class: xl63, align: right"]144.0064[/TD]
[TD="class: xl63, align: right"]143.5664[/TD]
[TD="align: right"]143.0064[/TD]
[TD="align: right"]142.3264[/TD]
[TD="align: right"]141.5264[/TD]
[/TR]
[TR]
[TD="align: right"]139.3125[/TD]
[TD="align: right"]140.8025[/TD]
[TD="align: right"]142.1725[/TD]
[TD="align: right"]143.4225[/TD]
[TD="align: right"]144.5525[/TD]
[TD="align: right"]145.5625[/TD]
[TD="align: right"]146.4525[/TD]
[TD="align: right"]147.2225[/TD]
[TD="align: right"]147.8725[/TD]
[TD="align: right"]148.4025[/TD]
[TD="align: right"]148.8125[/TD]
[TD="align: right"]149.1025[/TD]
[TD="class: xl63, align: right"]149.2725[/TD]
[TD="class: xl63, align: right"]149.3225[/TD]
[TD="class: xl63, align: right"]149.2525[/TD]
[TD="class: xl63, align: right"]149.0625[/TD]
[TD="class: xl63, align: right"]148.7525[/TD]
[TD="class: xl63, align: right"]148.3225[/TD]
[TD="align: right"]147.7725[/TD]
[TD="align: right"]147.1025[/TD]
[TD="align: right"]146.3125[/TD]
[/TR]
[TR]
[TD="align: right"]143.5584[/TD]
[TD="align: right"]145.0584[/TD]
[TD="align: right"]146.4384[/TD]
[TD="align: right"]147.6984[/TD]
[TD="align: right"]148.8384[/TD]
[TD="align: right"]149.8584[/TD]
[TD="align: right"]150.7584[/TD]
[TD="align: right"]151.5384[/TD]
[TD="align: right"]152.1984[/TD]
[TD="align: right"]152.7384[/TD]
[TD="align: right"]153.1584[/TD]
[TD="align: right"]153.4584[/TD]
[TD="class: xl63, align: right"]153.6384[/TD]
[TD="class: xl63, align: right"]153.6984[/TD]
[TD="class: xl63, align: right"]153.6384[/TD]
[TD="class: xl63, align: right"]153.4584[/TD]
[TD="class: xl63, align: right"]153.1584[/TD]
[TD="class: xl63, align: right"]152.7384[/TD]
[TD="align: right"]152.1984[/TD]
[TD="align: right"]151.5384[/TD]
[TD="align: right"]150.7584[/TD]
[/TR]
[TR]
[TD="align: right"]147.4089[/TD]
[TD="align: right"]148.9189[/TD]
[TD="align: right"]150.3089[/TD]
[TD="align: right"]151.5789[/TD]
[TD="align: right"]152.7289[/TD]
[TD="align: right"]153.7589[/TD]
[TD="align: right"]154.6689[/TD]
[TD="align: right"]155.4589[/TD]
[TD="align: right"]156.1289[/TD]
[TD="align: right"]156.6789[/TD]
[TD="align: right"]157.1089[/TD]
[TD="align: right"]157.4189[/TD]
[TD="class: xl63, align: right"]157.6089[/TD]
[TD="class: xl63, align: right"]157.6789[/TD]
[TD="class: xl63, align: right"]157.6289[/TD]
[TD="class: xl63, align: right"]157.4589[/TD]
[TD="class: xl63, align: right"]157.1689[/TD]
[TD="class: xl63, align: right"]156.7589[/TD]
[TD="align: right"]156.2289[/TD]
[TD="align: right"]155.5789[/TD]
[TD="align: right"]154.8089[/TD]
[/TR]
[TR]
[TD="align: right"]150.8064[/TD]
[TD="align: right"]152.3264[/TD]
[TD="align: right"]153.7264[/TD]
[TD="align: right"]155.0064[/TD]
[TD="align: right"]156.1664[/TD]
[TD="align: right"]157.2064[/TD]
[TD="align: right"]158.1264[/TD]
[TD="align: right"]158.9264[/TD]
[TD="align: right"]159.6064[/TD]
[TD="align: right"]160.1664[/TD]
[TD="align: right"]160.6064[/TD]
[TD="align: right"]160.9264[/TD]
[TD="class: xl63, align: right"]161.1264[/TD]
[TD="class: xl63, align: right"]161.2064[/TD]
[TD="class: xl63, align: right"]161.1664[/TD]
[TD="class: xl63, align: right"]161.0064[/TD]
[TD="class: xl63, align: right"]160.7264[/TD]
[TD="class: xl63, align: right"]160.3264[/TD]
[TD="align: right"]159.8064[/TD]
[TD="align: right"]159.1664[/TD]
[TD="align: right"]158.4064[/TD]
[/TR]
[TR]
[TD="align: right"]153.6909[/TD]
[TD="align: right"]155.2209[/TD]
[TD="align: right"]156.6309[/TD]
[TD="align: right"]157.9209[/TD]
[TD="align: right"]159.0909[/TD]
[TD="align: right"]160.1409[/TD]
[TD="align: right"]161.0709[/TD]
[TD="align: right"]161.8809[/TD]
[TD="align: right"]162.5709[/TD]
[TD="align: right"]163.1409[/TD]
[TD="align: right"]163.5909[/TD]
[TD="align: right"]163.9209[/TD]
[TD="class: xl63, align: right"]164.1309[/TD]
[TD="class: xl63, align: right"]164.2209[/TD]
[TD="class: xl63, align: right"]164.1909[/TD]
[TD="class: xl63, align: right"]164.0409[/TD]
[TD="class: xl63, align: right"]163.7709[/TD]
[TD="class: xl63, align: right"]163.3809[/TD]
[TD="align: right"]162.8709[/TD]
[TD="align: right"]162.2409[/TD]
[TD="align: right"]161.4909[/TD]
[/TR]
[TR]
[TD="align: right"]156[/TD]
[TD="align: right"]157.54[/TD]
[TD="align: right"]158.96[/TD]
[TD="align: right"]160.26[/TD]
[TD="align: right"]161.44[/TD]
[TD="align: right"]162.5[/TD]
[TD="align: right"]163.44[/TD]
[TD="align: right"]164.26[/TD]
[TD="align: right"]164.96[/TD]
[TD="align: right"]165.54[/TD]
[TD="align: right"]166[/TD]
[TD="align: right"]166.34[/TD]
[TD="class: xl63, align: right"]166.56[/TD]
[TD="class: xl63, align: right"]166.66[/TD]
[TD="class: xl63, align: right"]166.64[/TD]
[TD="class: xl63, align: right"]166.5[/TD]
[TD="class: xl63, align: right"]166.24[/TD]
[TD="class: xl63, align: right"]165.86[/TD]
[TD="align: right"]165.36[/TD]
[TD="align: right"]164.74[/TD]
[TD="align: right"]164[/TD]
[/TR]
[TR]
[TD="align: right"]157.6689[/TD]
[TD="align: right"]159.2189[/TD]
[TD="align: right"]160.6489[/TD]
[TD="align: right"]161.9589[/TD]
[TD="align: right"]163.1489[/TD]
[TD="align: right"]164.2189[/TD]
[TD="align: right"]165.1689[/TD]
[TD="align: right"]165.9989[/TD]
[TD="align: right"]166.7089[/TD]
[TD="align: right"]167.2989[/TD]
[TD="align: right"]167.7689[/TD]
[TD="align: right"]168.1189[/TD]
[TD="class: xl63, align: right"]168.3489[/TD]
[TD="class: xl63, align: right"]168.4589[/TD]
[TD="class: xl63, align: right"]168.4489[/TD]
[TD="class: xl63, align: right"]168.3189[/TD]
[TD="class: xl63, align: right"]168.0689[/TD]
[TD="class: xl63, align: right"]167.6989[/TD]
[TD="align: right"]167.2089[/TD]
[TD="align: right"]166.5989[/TD]
[TD="align: right"]165.8689[/TD]
[/TR]
[TR]
[TD="align: right"]158.6304[/TD]
[TD="align: right"]160.1904[/TD]
[TD="align: right"]161.6304[/TD]
[TD="align: right"]162.9504[/TD]
[TD="align: right"]164.1504[/TD]
[TD="align: right"]165.2304[/TD]
[TD="align: right"]166.1904[/TD]
[TD="align: right"]167.0304[/TD]
[TD="align: right"]167.7504[/TD]
[TD="align: right"]168.3504[/TD]
[TD="align: right"]168.8304[/TD]
[TD="align: right"]169.1904[/TD]
[TD="align: right"]169.4304[/TD]
[TD="align: right"]169.5504[/TD]
[TD="align: right"]169.5504[/TD]
[TD="align: right"]169.4304[/TD]
[TD="align: right"]169.1904[/TD]
[TD="align: right"]168.8304[/TD]
[TD="align: right"]168.3504[/TD]
[TD="align: right"]167.7504[/TD]
[TD="align: right"]167.0304[/TD]
[/TR]
[TR]
[TD="align: right"]158.8149[/TD]
[TD="align: right"]160.3849[/TD]
[TD="align: right"]161.8349[/TD]
[TD="align: right"]163.1649[/TD]
[TD="align: right"]164.3749[/TD]
[TD="align: right"]165.4649[/TD]
[TD="align: right"]166.4349[/TD]
[TD="align: right"]167.2849[/TD]
[TD="align: right"]168.0149[/TD]
[TD="align: right"]168.6249[/TD]
[TD="align: right"]169.1149[/TD]
[TD="align: right"]169.4849[/TD]
[TD="align: right"]169.7349[/TD]
[TD="align: right"]169.8649[/TD]
[TD="align: right"]169.8749[/TD]
[TD="align: right"]169.7649[/TD]
[TD="align: right"]169.5349[/TD]
[TD="align: right"]169.1849[/TD]
[TD="align: right"]168.7149[/TD]
[TD="align: right"]168.1249[/TD]
[TD="align: right"]167.4149[/TD]
[/TR]
[TR]
[TD="align: right"]158.1504[/TD]
[TD="align: right"]159.7304[/TD]
[TD="align: right"]161.1904[/TD]
[TD="align: right"]162.5304[/TD]
[TD="align: right"]163.7504[/TD]
[TD="align: right"]164.8504[/TD]
[TD="align: right"]165.8304[/TD]
[TD="align: right"]166.6904[/TD]
[TD="align: right"]167.4304[/TD]
[TD="align: right"]168.0504[/TD]
[TD="align: right"]168.5504[/TD]
[TD="align: right"]168.9304[/TD]
[TD="align: right"]169.1904[/TD]
[TD="align: right"]169.3304[/TD]
[TD="align: right"]169.3504[/TD]
[TD="align: right"]169.2504[/TD]
[TD="align: right"]169.0304[/TD]
[TD="align: right"]168.6904[/TD]
[TD="align: right"]168.2304[/TD]
[TD="align: right"]167.6504[/TD]
[TD="align: right"]166.9504[/TD]
[/TR]
[TR]
[TD="align: right"]156.5625[/TD]
[TD="align: right"]158.1525[/TD]
[TD="align: right"]159.6225[/TD]
[TD="align: right"]160.9725[/TD]
[TD="align: right"]162.2025[/TD]
[TD="align: right"]163.3125[/TD]
[TD="align: right"]164.3025[/TD]
[TD="align: right"]165.1725[/TD]
[TD="align: right"]165.9225[/TD]
[TD="align: right"]166.5525[/TD]
[TD="align: right"]167.0625[/TD]
[TD="align: right"]167.4525[/TD]
[TD="align: right"]167.7225[/TD]
[TD="align: right"]167.8725[/TD]
[TD="align: right"]167.9025[/TD]
[TD="align: right"]167.8125[/TD]
[TD="align: right"]167.6025[/TD]
[TD="align: right"]167.2725[/TD]
[TD="align: right"]166.8225[/TD]
[TD="align: right"]166.2525[/TD]
[TD="align: right"]165.5625[/TD]
[/TR]
[TR]
[TD="align: right"]153.9744[/TD]
[TD="align: right"]155.5744[/TD]
[TD="align: right"]157.0544[/TD]
[TD="align: right"]158.4144[/TD]
[TD="align: right"]159.6544[/TD]
[TD="align: right"]160.7744[/TD]
[TD="align: right"]161.7744[/TD]
[TD="align: right"]162.6544[/TD]
[TD="align: right"]163.4144[/TD]
[TD="align: right"]164.0544[/TD]
[TD="align: right"]164.5744[/TD]
[TD="align: right"]164.9744[/TD]
[TD="align: right"]165.2544[/TD]
[TD="align: right"]165.4144[/TD]
[TD="align: right"]165.4544[/TD]
[TD="align: right"]165.3744[/TD]
[TD="align: right"]165.1744[/TD]
[TD="align: right"]164.8544[/TD]
[TD="align: right"]164.4144[/TD]
[TD="align: right"]163.8544[/TD]
[TD="align: right"]163.1744[/TD]
[/TR]
[TR]
[TD="align: right"]150.3069[/TD]
[TD="align: right"]151.9169[/TD]
[TD="align: right"]153.4069[/TD]
[TD="align: right"]154.7769[/TD]
[TD="align: right"]156.0269[/TD]
[TD="align: right"]157.1569[/TD]
[TD="align: right"]158.1669[/TD]
[TD="align: right"]159.0569[/TD]
[TD="align: right"]159.8269[/TD]
[TD="align: right"]160.4769[/TD]
[TD="align: right"]161.0069[/TD]
[TD="align: right"]161.4169[/TD]
[TD="align: right"]161.7069[/TD]
[TD="align: right"]161.8769[/TD]
[TD="align: right"]161.9269[/TD]
[TD="align: right"]161.8569[/TD]
[TD="align: right"]161.6669[/TD]
[TD="align: right"]161.3569[/TD]
[TD="align: right"]160.9269[/TD]
[TD="align: right"]160.3769[/TD]
[TD="align: right"]159.7069[/TD]
[/TR]
[TR]
[TD="align: right"]145.4784[/TD]
[TD="align: right"]147.0984[/TD]
[TD="align: right"]148.5984[/TD]
[TD="align: right"]149.9784[/TD]
[TD="align: right"]151.2384[/TD]
[TD="align: right"]152.3784[/TD]
[TD="align: right"]153.3984[/TD]
[TD="align: right"]154.2984[/TD]
[TD="align: right"]155.0784[/TD]
[TD="align: right"]155.7384[/TD]
[TD="align: right"]156.2784[/TD]
[TD="align: right"]156.6984[/TD]
[TD="align: right"]156.9984[/TD]
[TD="align: right"]157.1784[/TD]
[TD="align: right"]157.2384[/TD]
[TD="align: right"]157.1784[/TD]
[TD="align: right"]156.9984[/TD]
[TD="align: right"]156.6984[/TD]
[TD="align: right"]156.2784[/TD]
[TD="align: right"]155.7384[/TD]
[TD="align: right"]155.0784[/TD]
[/TR]
[TR]
[TD="align: right"]139.4049[/TD]
[TD="align: right"]141.0349[/TD]
[TD="align: right"]142.5449[/TD]
[TD="align: right"]143.9349[/TD]
[TD="align: right"]145.2049[/TD]
[TD="align: right"]146.3549[/TD]
[TD="align: right"]147.3849[/TD]
[TD="align: right"]148.2949[/TD]
[TD="align: right"]149.0849[/TD]
[TD="align: right"]149.7549[/TD]
[TD="align: right"]150.3049[/TD]
[TD="align: right"]150.7349[/TD]
[TD="align: right"]151.0449[/TD]
[TD="align: right"]151.2349[/TD]
[TD="align: right"]151.3049[/TD]
[TD="align: right"]151.2549[/TD]
[TD="align: right"]151.0849[/TD]
[TD="align: right"]150.7949[/TD]
[TD="align: right"]150.3849[/TD]
[TD="align: right"]149.8549[/TD]
[TD="align: right"]149.2049[/TD]
[/TR]
[TR]
[TD="align: right"]132[/TD]
[TD="align: right"]133.64[/TD]
[TD="align: right"]135.16[/TD]
[TD="align: right"]136.56[/TD]
[TD="align: right"]137.84[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]140.04[/TD]
[TD="align: right"]140.96[/TD]
[TD="align: right"]141.76[/TD]
[TD="align: right"]142.44[/TD]
[TD="align: right"]143[/TD]
[TD="align: right"]143.44[/TD]
[TD="align: right"]143.76[/TD]
[TD="align: right"]143.96[/TD]
[TD="align: right"]144.04[/TD]
[TD="align: right"]144[/TD]
[TD="align: right"]143.84[/TD]
[TD="align: right"]143.56[/TD]
[TD="align: right"]143.16[/TD]
[TD="align: right"]142.64[/TD]
[TD="align: right"]142[/TD]
[/TR]
</tbody>[/TABLE]

Fluff · Oct 19, 2019

If I select the part with borders I get 168.4589 in N42 which is correct for where I have the data.
Check that your values are numbers & not text.

xiahuagreen · Oct 19, 2019

Hi thanks for the response. the thing that amazes me is everything works down to line row 21 or 22, as expected (the requirement is to select a zoom area and find the max value and color that cell with different color). once the zoom extends pass the row 21, 22, the program fails. is there a magical line that excel spread sheet cannot pass?

JoeMo · Oct 19, 2019

Fluff's code works fine for me using the data you posted, provided that I change the Find Method line to this:

Code:

Set MaxCell = zoomRng.Find(169.875, LookIn:=xlFormulas, lookat:=xlWhole, searchorder:=xlByRows)

The reason for using xlFormulas instead of xlValues is that if you run the macro multiple times with xlValues, after the first time it doesn't find the maxvalue (MaxCell is Nothing) for me, apparently b/c the first run causes the data to re-format to fewer decimal places. Using xlFormulas finds the correct value repeatably b/c it looks for the 'Formula" value which is what you see when you select a cell and look at the value in the formula bar.

For your full data set, placing the upperleft-most cell in A1, the max value is 169.8749 in cell $O$44.

xiahuagreen · Oct 20, 2019

Thank you for the explanation.
I think the search maxcell routine can find the max value, but the maxcell address routine could not record it, when all the cycles completed, the cell address has lost, ends up no way to highlight it that's why the error comes up with "range... color=22" ...
what I need to do: I can write out the max value in a remote cell, retrieve that value after the search is done, and compare that value within the zoomrng cell values, find the match and write out the address and color it.

Fluff · Oct 20, 2019

I think the search maxcell routine can find the max value, but the maxcell address routine could not record it

The search cannot find the Max value, that's why you get the message "No Max value found"

Based on JoeMo's suggestion try

Code:

Set MaxCell = zoomRng.Find(maxvalue, , xlFormulas, xlWhole, , , , , False)

'Range' of object '_Global' failed ---runtime error 1004

xiahuagreen

New Member

Excel Facts

Fluff

MrExcel MVP, Moderator

xiahuagreen

New Member

Fluff

MrExcel MVP, Moderator

xiahuagreen

New Member

Fluff

MrExcel MVP, Moderator

xiahuagreen

New Member

JoeMo

MrExcel MVP

xiahuagreen

New Member

Fluff

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

'Range' of object '_Global' failed ---runtime error 1004

New Member

Excel Facts

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP

New Member

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock