WorksheetFunction.Large in VBA

[austinpcherry]

While am I getting an "Invalid Qualifier" error when I try and use the Large function? I am using it like:

Champ1 = Range(WorksheetFunction.Large(Arg1:=Range("O1", "V129"), Arg2:=1).Offset.End(xlToLeft).Value)

Thank you for your help in advance.

 

[austinpcherry]

*Why as I ......

 

[skywriter]

You have the large function wrapped inside of range.

Range expects a range, large returns a number.

What exactly are you hoping to do?

What is in these cell that are referenced in the large function?

 

[austinpcherry]

I have a range of numbers that are populated from user entry. The numbers in the range are the number of times a combination of the row header and the column header both appear in the user entry. I then want the row header and the column header of the most entered combinations, hence the Large function and the offset.
So how do I get the address of the Large 1,2,3,4,5 so I can get the row and column headers?

I have Items listed in the row headers and Geographic areas listed in the column headers. When an order is processed it adds one to the cell in the crossing of the item and area. I want to know which item in which area are my top 5 sellers.

 

[skywriter]

You'll have to post a screen shot with a small data sample and tell me what you want based on the data shown.

Large is only going to get you a number, you can't get a range from that.

If the number is unique you could use match or find etc. to get a column and/or row from matching the number.

I'm sure we can help you, but we're going to have to see what you are talking about in order to figure out the best code.

 

[austinpcherry]

Ok, I will have to do that from a different computer later. The numbers definately will not be unique. I tried to use the Large function just on the worksheet. I tried to use indirect(address(Large(blah, blah) and it kind of works, but it does not deal with duplicates that way. It just shows two of the same entry. If I have 20 items sole in the NW region and 20 in the SW region I need to know both of those values, not just NW twice. I tried to use find and findnext but I got lost there as well. When I get to my other computer I will post a screenshot. Maybe it will make more sense then.