<p>Data processing, dynamic reporting, and workbook automation.</p>
At the moment I'm converting a project written in VBA to Delphi and have stumbled upon a problem with converting some Subs with Optional…
I have a short list of values from A1 through A10: A4 contains the string ab and A5 contains the formula: ="a" & "b"…
It is pretty much widely accepted that this is not 'best practise'. dim rng as range with thisworkbook '<~~ possibly set an external workbook…
I have written a piece of code that allows me to retrieve the shading color of a specific cell inside a sheet of an…
How can I find the last row in a range of cells that hold a formula, where the result of the formula is an…
When the results of an Array Formula are numbers, I find it generally easy to find an appropriate method to collapse the array into…
Is there a way to achieve this in EPPlus? Only thing I could find on the internet is grouping specific data for example: AAA…
I've been using this Excel formula for years. It works fine, but I want to understand why it works! The formula is used to…
I am trying to get I/O as follows: Input : 123490 Output : BCDEJA Logic is simple: if strarr(i)=0,1,2,3,4,5,6,7,8,9 then strarr(i) should be =…
This seems silly, but I haven't been able to get my values in the format of #/#### to write as the literal string rather…