dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Visual Basic > Visual Basic For Applications (vba)

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
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date