You're welcome & thanks for the feedback
Posts by Fluff13
-
-
-
Glad to help & thanks for the feedback
-
How about
=INDEX(H5:K12,MATCH(G18,G5:G12,0),MATCH(H18,H4:K4,0))
although I think the result should be 16 not 46
-
Glad you sorted it & thanks for the feedback.
-
Are you sure they are ActiveX controls & not Form controls?
Also was the correct sheet active when you ran that code?
-
You're welcome & thanks for the feedback.
-
You need to qualify the evaluate, or it's looking at the active sheet
Code- Dim v, ws As Worksheet
- Dim vRws As Variant
- Set ws = ThisWorkbook.Worksheets("Sheet1")
- With ws.ListObjects("Table1").DataBodyRange
- vRws = Filter(Application.Transpose(ws.Evaluate(Replace(Replace("if(#=FALSE,row(#)-~,""X"")", "#", .Columns(35).Address), "~", .Rows(0).row))), "X", False)
- v = Application.Index(.Value2, Application.Transpose(vRws), Array(1, 14, 15)
-
Glad to help & thanks for the feedback.
-
-
-
-
You're welcome & thanks for the feedback.
-
In that case add 1 to i in the index
-
-
-
-
I just get the 3 relevant rows from cols A, Q & R
-
-
Line 125 is also a problem. Not sure how to represent the "selected item" of the combo box in the If/Then statement, as .Selected(row) doesn't work the same as for a listbox.
I have no idea what you are trying to do with that portion of the code.