Visual Basic For Applications (vba)

4 of 4 Previous Next
Passing Strings Between Delphi DLL and VBA by Romeo Besas Unlike other routines, this one doesn't need to pass the length of the returned string for later Trimming in VBA.
Converting Numbers to Column Names in Excel 2007 by John P. While converting to Excel 2007, I had to update the column number to string code in my program to handle columns of 703 and above (AAA). I found Yassine Moe's code and "simplified" it. This tip shows the results.
Count the Number of Cells Containing a Specified String in a Worksheet by Alistair Evans Simply insert this function into a module to count the number of cells with a specified string in a worksheet.
Convert Numbers to Excel Column Names by Yassine Moe This algorithm converts column numbers (1-x) to Excel column names.
4 of 4 Previous Next

Thanks for your registration, follow us on our social networks to keep up-to-date