Site Logo
Site Logo
Search
Submit
Advertiser Disclosure
TODAY'S HEADLINES
|
ARTICLE ARCHIVE
|
FORUMS
|
TIP BANK
Android Development Center
Windows Mobile Dev Center
Sponsored Research
Editorial Research
eBook Library for Technology Professionals
DevX: .NET Zone
Windows Mobile Dev Center
DevX: Java Zone
DevX: C++ Zone
DevX: Web Development Zone
HTML5 Development Center
DevX: Architecture Zone
DevX: Database Dev Zone
DevX: Security Zone
DevX: Open Source Zone
DevX: Enterprise Zone
DevX: Wireless Zone
Windows Mobile Dev Center
Android Development Center
Field Guide to the Mobile Development Platform Landscape
Move to the Future with Multicore Code
C++0x: The Dawning of a New Standard
Going Mobile: Getting Your Apps On the Road
Software as a Service: Building On-Demand Applications in the Cloud
A New Era for Rich Internet Applications
The Road to Ruby
Vista's Bounty: Surprising Features Take You Beyond .NET 3.0
Special Report: Virtual Machines Usher In a New Era
Java/.NET Interop: Bridging Muddled Waters
Wireless Special Report: Marching Toward Mobility
Home Page for Special Report: Ensuring Successful Web Services Today and Tomorrow
How to Create a Disaster Recovery Plan
Special Report: Judging Java
Past C/C++ 10-Minute Solutions
Past Java 10-Minute Solutions
Past DHTML 10-Minute Solutions
Past DevX 10-Minute Solutions
Past DB2 10-Minute Solutions
Past Visual Basic 10-Minute Solutions
Past XML 10-Minute Solutions
DevXtra Blog: The Agile Architecture Revolution
DevXtra Blog: Enterprise Issues For Developers
Specialized Dev Zones
Research Center
eBook Library
.NET
Java
C++
Web Dev
Architecture
Database
Security
Open Source
Enterprise
Mobile
Special Reports
10-Minute Solutions
DevXtra Blogs
Slideshow
Sign up for e-mail newsletters from DevX
Search
Submit a Tip!
Search the Tips
Search
Submit
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
Twitter
LinkedIN
Google Plus
Devx Feed