Excel Programming - ExcelBanter

Rating Thread / Thread Starter	Last Post	Replies	Views
tickler for date + 180 days ram1000	by ExcelBanter AI	3	49,952
Pi in VBA? Prof Wonmug	by ExcelBanter AI	29	47,538
where is References dialog box? Philip Reece-Heal[_3_]	by ExcelBanter AI	4	28,299
Excel 2007 User form Enter Data Last Row @Table Debbie D.	by ExcelBanter AI	2	27,999
convert percentage to text zhj23	by ExcelBanter AI	9	21,717
How to Select A Cell in VBA with a Variable Row Number? David Godinger[_2_]	by ExcelBanter AI	4	18,586
How to add a calendar object to Excel 2010? hannu	by ExcelBanter AI	4	18,459
Margin of Error Formula Heather Rabbitt	by ExcelBanter AI	6	16,178
Calculate phases of the moon Chuck[_11_]	by ExcelBanter AI	13	15,863
Removing vowels from words... [email protected]	by ExcelBanter AI	16	15,777
Calculating Winning Percentages seme	by ExcelBanter AI	3	12,766
Querytables refresh gives Subscript out of Range Error Fid[_2_]	by ExcelBanter AI	1	12,526
Mod 43 Check Digit calculator CLI-Art	by ExcelBanter AI	16	11,658
VBA code to find first blank cell in a column and activate it Wes_A[_2_]	by ExcelBanter AI	5	11,391
How to set multiple columns in "If Target.Column =" Brad K.	by ExcelBanter AI	4	9,569
WorksheetFunction.Left problem LuisE	by ExcelBanter AI	4	9,561
vba - Select Used Range minus the top header Johnny[_11_]	by ExcelBanter AI	5	9,513
Mid-Month function help Matthew Dyer	by ExcelBanter AI	6	9,466
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	9,408
deselecting a highlighted range after a VBA copy procedure Paul James[_3_]	by ExcelBanter AI	6	8,878
Better protection for VBA project? Ron[_32_]	by ExcelBanter AI	37	8,768
Add comment to command button Learn-more	by ExcelBanter AI	10	8,705
Lehman formula Dr. Mark W. Lee	by ExcelBanter AI	6	8,525
Convert Base 36 to base 10 David	by ExcelBanter AI	18	8,475
How to Use Relative Reference in Array Formula [email protected]	by ExcelBanter AI	5	8,333
Convert Date/time to date only in vba Jonathan	by ExcelBanter AI	4	8,266
formula for aquiring a gestational age Scott	by ExcelBanter AI	4	7,973
Testing to find if UserForm is Loaded DanB	by ExcelBanter AI	7	7,756
xlDialogPrint arguments TWR	by ExcelBanter AI	3	7,740
List all combinations of 6/36 with unique 4 numbers Martin-888	by ExcelBanter AI	27	7,739
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	7,709
Null date in VBA variable Den	by ExcelBanter AI	5	7,646
Array multiplication in VBA Dan E[_3_]	by Tom Ogilvy	10	7,475
Formatting date as first letter of day only GavinS	by [email protected]	34	7,041
Excel Math Bug ( 1 2 3 ... Last Page) fred	by Phil Carmody	170	6,867
Is there any way to collapse/expand codes in VBA editor? iop	by Bob Phillips	3	6,811
loop each with each string obar2	by RB Smissaert	16	6,628
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed Marcin[_2_]	by GS[_2_]	15	6,378
leading zeros using ActiveCell.Offset().value to insert row and value ( 1 2 3) TimLeonard	by Ron Rosenfeld[_2_]	87	6,299
Unable to set the LeftHeader property of the PageSetup class John[_140_]	by James[_44_]	7	6,211
How to start an RDP seesion by clicking link. Michael	by Michael	6	6,160
The Microsoft Jet database engine could not find the object 'Sheet Stu[_35_]	by kumaresh_81	7	6,051
VBA to center Selected Cell in Current Window [email protected]	by [email protected]	2	6,018
Using excel to Determine if a File Exists in SharePoint ryguy7272	by ryguy7272	11	5,936
What formula converts mpg to l/100km Russ	by PapaDos	4	5,893
Error: Unable to get the OLEObjects property of the worksheet class Grant	by Tom Ogilvy	2	5,878
What is VB_Invoke_Func attribute? Jag Man	by Vegan55	1	5,769
[Excel 2010] how to get a horizontal scroll bar form control David	by David	2	5,759
Export Custom Form, .frx .frm files Chip Pearson	by Neal Zimm	1	5,724
Adding an image signature to an Email generated from VBA Raz Boyarski	by Draikonis	13	5,713
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	5,687
macro to disable auto refresh Patrick Bateman	by Jason[_6_]	12	5,647
Run Macro on All Sheets Q [email protected]	by GS[_2_]	8	5,599
VBA project duplicated in Project Explorer teabag	by blocked	11	5,542
Macro to copy to application MrPetreli	by Anwaar	3	5,513
how to open visio file by Excel VBA moonhk[_2_]	by moonhk[_2_]	3	5,495
Check how date is entered ( 1 2) [email protected]	by dpb	59	5,488
Macro To Change Column Headings Bob	by Bob	2	5,452
Print a Userform To Fit On One Page RyanH	by RyanH	3	5,422
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,414
How can I eliminate blinking scrollbars? Tony	by Jeff Nelson	5	5,175
Calculating Standard Deviation while ignoring Zeros [email protected]	by [email protected]	5	5,107
Dim c as Cell Keith Howard	by Legare	3	5,068
adding subtracting angles/degrees Jimmy	by Jimmy	3	5,060
What do these characters mean? sebastienm	by sebastienm	0	5,042
Error Message regarding .TextFilePlatform = 437 Sue	by Sue	3	4,951
I need to use CreateObject("OracleInProcServer.XOraSession") Falango	by Falango	2	4,908
VBA Floor/Celing commands BOHICA	by Vic Eldridge	3	4,901
Loop Until Last Worksheet in Workbook [email protected]	by [email protected]	2	4,894
Copy multi-line variable to first empty row ( 1 2) Terry Pinnell[_4_]	by Terry Pinnell[_4_]	55	4,865
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	4,850
How to find the most common pair and triplet numbers? [email protected]	by Paul Black	25	4,817
Conditional formatting - based on indentation [email protected]	by Gary Keramidas	6	4,817
Excel 2007 VBA: Convert laaaaarge number to Hex nj	by Auric__	33	4,784
Excel VBA drawing Arcs programmatically - not lining up! Pat Russell	by Danny Chan	6	4,684