Forum

They are - Enums can only be whole numbers.

You can still do what I suggested, you just need to make that part into a function. Create a query that loads one of the tables in, and then keeps jus...

In the PQ UI there is a Keep Rows dropdown that allows you to specify to keep the bottom n rows. Just choose 1 for the number to keep.

I think it should actually be: MsgBox "Elapsed time: " & Format((Now() - StartTime), "hh:mm:ss")

The form designer hasn't been available in Mac Excel since 2011. I'd suggest data validation might be the best option available, but there isn...

I imagine Serge is referring to the fact that you cannot create or design userforms in current versions of Mac Excel (2016 / 2019 / 365) due to the li...

Just my tuppence worth: don't use activex controls unless you absolutely have to. They are liable to behave strangely or stop working altogether, part...

You can use an array formula like this: =INDEX($A$2:$A$12,MATCH(MIN(IF($B$2:$B$12=$E$1,ABS($A$2:$A$12-$E$2))),IF($B$2:$B$12=$E$1,ABS($A$2:$A$12-$E$...

Thanks for letting me know.

Hi Sunny, In what way did it not work? (Adding Call is never necessary in VBA)

This should work: =SUMPRODUCT(--($D$3:$D$88="BP.TF➤MP.TF"),$G$3:$G$88,$E$3:$E$88)

All you need to do is select the cells containing the URLs and then run the loadPictures macro (note: I assumed that all the selected cells will have ...

You can use a simple loop: Sub loadPictures() For Each cell In Selection addpic cell.Value, cell.Offset(, -1) Next cell End Sub Sub addpic(url...

You're welcome.

I think you could use something like: =LOOKUP(B2,PERCENTILE.INC($B$2:$B$10,{0,0.06,0.28,0.5,0.73,0.95}),{2,3,4,5,6,7}) where B2:B10 ha...