VBA Method 'Range' of object '_Global' failed error

**RxMiller** · 08-30-2011, 10:47 AM

VBA Method 'Range' of object '_Global' failed error
ObjXL is a variable in MS Access code.
There are two dozen working Access functions that use Excel VBA to create custom reports.
This error appeared when this code was added to a working function.
It appears to have worked once (when the workstation was rebooted) and then failes at line 1280 after that.
Update: sure enough, it works one time with the debugger halted on 1300 and then a step through
The second time -it failes at 1300

Please Login or Register  to view this content.

**Bob Phillips** · 08-30-2011, 10:59 AM

You need to qualify the range object with its worksheet/workbook parentage.

**RxMiller** · 08-30-2011, 11:06 AM

1300 .ActiveWorkbook.Worksheets("T_84 Report").Sort.SortFields.Add Key:=ObjXL.Range( _
"A6:A3338"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
(and three other Range objects in the code above)
You are so correct!
I just figured it out, tested it and came back to update this post. Thanks so much!