Forum

If you're trying to only pick up the new data as a pivot table, you can't do that, since the headers aren't adjacent to the data.

You can't use three criteria arrays (assuming you want all possible combinations) like that. Are there other options in column F that begin with "Trad...

If you're trying to use Worksheetfunction.Filter, the second argument needs to be an array of True/False values and oriented the correct way (ie if yo...

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 ...