Posts by Fluff13

You need to move the check for A10 being empty, before you try to find the value in the data sheet.

You're welcome & thanks for the feedback.

Row 722 has a row height of 0, which is the cause of the discrepancy

Probably a different type of apostrophe.

What does =CODE(MID(A1,6,1)) return?

146, 39 or something else.

In that case can you please supply a sample workbook.

If the nickname is in column F why is the formula looking at column T?

You're welcome & thanks for the feedback.

How about

=MEDIAN(IF(($A$2:A$360=I2)*($B$2:B$360=J2)*($C$2:C$360=K2),$F$2:F$360))

May need CSE entry depending on your version of Excel.

Hi & welcome to the board.

How about

Sub tmyflyte()
   Dim UsdRws As Long
   
   UsdRws = Range("U:U").Find("*", , xlValues, , xlByRows, xlPrevious, , , False).Row
   If UsdRws > 9 Then Range("U9:AS" & UsdRws).Copy
End Sub

You're welcome & thanks for the feedback.

I'm still none the wiser, about what you are trying to do, but as far as I know you cannot use Index on a jagged array the way you are trying to do.

In that case can you please supply a workbook, with your data & complete code.

Not entirely sure what your aim is, but you can retrieve certain columns from an array like

   Dim a As Variant, b As Variant
   a = Range("A1:Z20").Value
   b = Application.Index(a, Evaluate("row(1:" & UBound(a) & ")"), Array(2, 3, 4))

Glad you sorted it & thanks for the feedback.

Make sure that the headings in Rows 1 & 7 exactly match the headings of your data.

Odd, it works for me, can you supply a copy of your workbook?

You're welcome & thanks for the feedback.

I've learnt most of what I know through helping out on sites like this.

That's the name of the workbook not the sheet, change it to Sheet1

How about

Sub sleeplol()
   Dim Rng As Range
   
   With Sheet16
      Set Rng = .Range("J7", .Cells(7, Columns.Count).End(xlToLeft))
   End With
   Sheet19.Range("F7").CurrentRegion.AdvancedFilter xlFilterCopy, Sheet16.Range("J1:AJ2"), Rng, False
End Sub

In that case the sheet name is wrong.

You need to change Test to what the name of the sheet is, as seen on the tab.