Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2000
Can anybody help? I get a " Method 'Range' of object '_Worksheet' failed " error message when I run this code: Private Sub Worksheet_selectionChange(ByVal Target As Range) If ActiveCell = "Sun" Then LUPVALUE = Range("f129") result = Application.WorksheetFunction _ .VLookup(LUPVALUE, Range("testrange"), 2, False) Application.StatusBar = "Total Orders = " & result Else Application.StatusBar = "" End If Application.Calculate End Sub Can you let me know how to fix this. Regards George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range error | Excel Discussion (Misc queries) | |||
out of range error | New Users to Excel | |||
Type Mismatch error & subscript out of range error | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Adding named range gives error "method range of object _Global failed " | Excel Programming |