ranking Sort Sort   |   date Sort Sort   |   member Sort Sort
Syndication

0
Date Submitted Mon. Jul. 5th, 2010 6:58 PM
Revision 1
Helper Stefan0410
Tags excel | Hash | hashtable | VB | VBA
Comments 0 comments
A simple HashTable Function in VBA, incl. checking for unique key.
0
Date Submitted Sat. Dec. 20th, 2008 3:10 AM
Revision 1
Beginner suin
Tags excel | macro | VBA
Comments 0 comments
This macro is recalculating selected cells with showing the progress bar in bottom status bar.

Progress bar example :

しばらくお待ちください。再計算しています。| ***_______ | 35% | 35/100 |
0
Date Submitted Tue. Dec. 16th, 2008 11:26 PM
Revision 1
Beginner suin
Tags excel | macro | VBA
Comments 0 comments
This script is a simple macro program which recalculate selected cells in Excel.
0
Date Submitted Mon. Dec. 15th, 2008 6:57 AM
Revision 1
Beginner suin
Tags excel | Password | Random | VBA
Comments 0 comments
This is a function which generates random letters for password. Programers can use this at Microsoft Excel and so on.
7
Date Submitted Tue. Sep. 4th, 2007 11:34 PM
Revision 1
Helper explode
Tags excel | mysql | PHP | query
Comments 1 comments
This is a cool function that lets you save MySQL query data to an Excel spreadsheet. This is good for taking a backup or if you want to change a lot of information fast, then re-upload it.

I will use the config.php and class.mysql.php files from MySQL DB Class with Extras, so please look at those also.
5
Date Submitted Fri. Oct. 27th, 2006 8:30 AM
Revision 1
Helper RobHarrigan
Tags count | excel | group | macro | tally
Comments 0 comments
Excel macro to group and count the number of items in a range of cells, delimited by the pipe character "|". It returns a summary of the items including a percent of total and count for each item found, plus a grand total of all items.

Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.


Sample Data:
--------------
cat|dog|bird
--------------
cat|bird
--------------
cat
--------------
frog

==================
OUTPUT from =total(A1:A4)
==================
42.9% - 3: cat
28.6% - 2: bird
14.3% - 1: dog
14.3% - 1: frog
---
7
2
Date Submitted Fri. Oct. 6th, 2006 3:12 PM
Revision 1
Helper BrandonReese
Tags excel | footer | VBA
Comments 0 comments
This macro will add a footer to your Excel worksheets. I use this at work because every Excel spreadsheet I do has to have my department and initials in the footer. This macro checks to make sure you are the author of the workbook, and it will not overwrite an existing footer. Just place this code in your personal macro workbook in the ThisWorkbook object.