Microsoft Access Office VB VBA Help and Examples  Microsoft Access Help      Search      Privacy      Contact    
 HOME     MS ACCESS     MS OUTLOOK     MS EXCEL     VB and VBA     FREE PROGRAMS     iPAQ     PERSONAL 

Microsoft Excel

We've all done a bit of excel in our time. Thought we were a bit flash with our clever functions and such. But did you know you can program excel to a very complex level almost making it a full blown application.

Chris Shepherd our resident excel GURU takes us through some advanced examples.

If you can't find what your looking for let us know. A page could be put up to cover it.

If we get enough pages up we will expand the section into sub sections

Weighted Average FunctionChris Shepherd
A replacement for the lack of a weighted average function in excel. Great for Lotus convertees.
How to move to a different cell once a cell has been modifiedChris Shepherd
Very clever piece of code from our Excel Guru Chris showing you how to decide the cell order in Excel Worksheets
Setting a worksheet name in code Chris Shepherd
How to rename a worksheet you've just created in code.
How to Join Cells in ExcelChris Shepherd
An often asked and very simple solution to join two text cells together in excel
Vlookup using multiple keysChris Shepherd
How to extend the powerful vlookup function in excel to use multiple keys
 
HOME   SEARCH SITE   PRIVACY POLICY   CONTACT
The code and application content of this site is copyright of Smiley I.T. and as such reproduction in any form which is for commercial use requires the permission of the Webmaster. Any use of this code for non-commercial use only requires a link or comment back to the original page you took the code from.