Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match
XL2000
I am trying to use the match function, by modifying some existing code . The original code is for a row but the new code is for a column. The problem is that is not selecting the right cell. Instead it is selecting the cell one column to the left and up one. I have tried playing with the settings but cannot get it too select the cell I want. Below is the code I am using. Any help would be greatly appreciated. Dim F As Single Dim FPos As Long Dim FRng As Range F = Application.WorksheetFunction.Max(.Range("CY12:CY1 6")) FPos = WorksheetFunction.Match(F, .Range("CY12:CY16"), 0) Set FRng = .Range("CY12:CY16").Cells(1, FPos) FRng.Select It should select CY13 but it select CX12 Ta, Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |