Activity Stream

Post for later API notes and tests

you wanted an explanation of the formula (how it works), not a check of the result check step by steep: reduce lambda vstack take

Thanks for your explanation but final result is 0 4 7 9 10 i can't understand

maybe it will help: The expression you provided is a formula in Excel or Google Sheets that uses the `REDUCE` function along with `LAMBDA`,...

This is post #554 https://www.excelfox.com/forum/showthread.php/2824-Tests-Copying-pasting-Cliipboard-issues/page56#post24879 ...

This is post #553 https://www.excelfox.com/forum/showthread.php/2824-Tests-Copying-pasting-Cliipboard-issues/page56#post24324...

This is post #552 https://www.excelfox.com/forum/showthread.php/2824-Tests-Copying-pasting-Cliipboard-issues/page56#post24323...

This is post #7 https://www.excelfox.com/forum/showthread.php/2986-Version-Info-using-VBA-and-registry-quirks?p=24876&viewfull=1#post24876...

Hi Profowo Thanks for the screenshots. I re tried your file on different computers, with Excel versions 2007, 2010, 2013 and 2016, but I still see...

@Alan kindly find the screen shot of the UserForm look like

Thanks Alan, If you critically observe the codes,it is meant for Dynamic Menu Page navigation for Label and Multipage with effects. Don't know why...

Hello Profowo I see you have been a member here for almost a year, but this is the first Thread I see of yours, so a belated welcome to ExcelFox...

This is post #551 https://www.excelfox.com/forum/showthread.php/2824-Tests-Copying-pasting-Cliipboard-issues/page56...

- Spare post for later related to these current posts ...

You can use the following VBA code to extract Outlook GAL email addresses using aliases for multiple rows: Sub GetExchangeUserDetailsFromAlias() ...

The issue is that ActiveDocument refers to the dotm file itself, not the document being opened. Try changing ActiveDocument to ThisDocument in your...

A data recovery tool should do the job. You can try SalvageData. It's free, and you won't lose anything by trying it.

I work with Java and might be able to help you out with generating XML files from your sequential file. Using a Java app to read the file and produce...

I've been stuck on this exact issue too! Adding digital signatures to PDFs using VBA can be a real pain. Robin77's suggestion to use a PDF library...

Hi, For keeping your model updated, you might want to: Centralize Assumptions: Put all key numbers in one sheet for easy updates. Use Named...

Hey Emmanuel, Instead of VLOOKUP, try using INDEX and MATCH for more flexibility across sheets. For Sales 2021, you can use: ...

Just use this formula =SUM(SUMIF(INDIRECT("'"&$H$1:$H$4&"'!A2:A99"), A2, INDIRECT("'"&$H$1:$H$4&"'!C2:C99"))) on your master sheet, where H1:H4...

I suggest to use Power Query (What is Power Query)

Hi, It's great to hear that you're diving into VBA for your work in asset management and investment, especially with such a significant focus on...