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

X

xiahuagreen

New Member
Joined
Oct 19, 2019
Messages
5
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
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
 
Upvote 0
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
Click to expand...
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?
 
Upvote 0
You need to delete your original macro, or change the name of one of them.
 
Upvote 0
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?
Click to expand...
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]
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
I think the search maxcell routine can find the max value, but the maxcell address routine could not record it
Click to expand...
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)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Method Range of Object _global Failed
Replies
2
Views
724
RoryA
RoryA
M
  • Question Question
Sheet code runtime error 1004
Replies
3
Views
159
MeaclH
M
D
  • Solved
Error 1004
2
Replies
18
Views
276
dmt32
D
2
  • Question Question
Run=time error '1004': Method 'Range of Object'_Global' failed
Replies
4
Views
633
2077delta
2
R
  • Question Question
Runtime Error 91
2
Replies
15
Views
616
rtr1811
R

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top