Excel Programming - ExcelBanter

Rating Thread / Thread Starter	Last Post	Replies	Views
tickler for date + 180 days ram1000	by ExcelBanter AI	3	49,955
Pi in VBA? Prof Wonmug	by ExcelBanter AI	29	47,546
where is References dialog box? Philip Reece-Heal[_3_]	by ExcelBanter AI	4	28,308
Excel 2007 User form Enter Data Last Row @Table Debbie D.	by ExcelBanter AI	2	28,004
convert percentage to text zhj23	by ExcelBanter AI	9	21,733
How to Select A Cell in VBA with a Variable Row Number? David Godinger[_2_]	by ExcelBanter AI	4	18,591
How to add a calendar object to Excel 2010? hannu	by ExcelBanter AI	4	18,462
Margin of Error Formula Heather Rabbitt	by ExcelBanter AI	6	16,179
Calculate phases of the moon Chuck[_11_]	by ExcelBanter AI	13	15,871
Removing vowels from words... [email protected]	by ExcelBanter AI	16	15,789
Calculating Winning Percentages seme	by ExcelBanter AI	3	12,774
Querytables refresh gives Subscript out of Range Error Fid[_2_]	by ExcelBanter AI	1	12,527
Mod 43 Check Digit calculator CLI-Art	by ExcelBanter AI	16	11,675
VBA code to find first blank cell in a column and activate it Wes_A[_2_]	by ExcelBanter AI	5	11,396
How to set multiple columns in "If Target.Column =" Brad K.	by ExcelBanter AI	4	9,580
WorksheetFunction.Left problem LuisE	by ExcelBanter AI	4	9,566
vba - Select Used Range minus the top header Johnny[_11_]	by ExcelBanter AI	5	9,519
Mid-Month function help Matthew Dyer	by ExcelBanter AI	6	9,470
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	9,450
deselecting a highlighted range after a VBA copy procedure Paul James[_3_]	by ExcelBanter AI	6	8,888
Better protection for VBA project? Ron[_32_]	by ExcelBanter AI	37	8,781
Add comment to command button Learn-more	by ExcelBanter AI	10	8,712
Lehman formula Dr. Mark W. Lee	by ExcelBanter AI	6	8,531
Convert Base 36 to base 10 David	by ExcelBanter AI	18	8,483
How to Use Relative Reference in Array Formula [email protected]	by ExcelBanter AI	5	8,337
Convert Date/time to date only in vba Jonathan	by ExcelBanter AI	4	8,284
formula for aquiring a gestational age Scott	by ExcelBanter AI	4	7,977
Testing to find if UserForm is Loaded DanB	by ExcelBanter AI	7	7,760
xlDialogPrint arguments TWR	by ExcelBanter AI	3	7,747
List all combinations of 6/36 with unique 4 numbers Martin-888	by ExcelBanter AI	27	7,744
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	7,729
Null date in VBA variable Den	by ExcelBanter AI	5	7,662
Array multiplication in VBA Dan E[_3_]	by Tom Ogilvy	10	7,478
Formatting date as first letter of day only GavinS	by [email protected]	34	7,045
Excel Math Bug ( 1 2 3 ... Last Page) fred	by Phil Carmody	170	6,886
Is there any way to collapse/expand codes in VBA editor? iop	by Bob Phillips	3	6,812
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,303
Unable to set the LeftHeader property of the PageSetup class John[_140_]	by James[_44_]	7	6,218
How to start an RDP seesion by clicking link. Michael	by Michael	6	6,166
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,019
Using excel to Determine if a File Exists in SharePoint ryguy7272	by ryguy7272	11	5,939
What formula converts mpg to l/100km Russ	by PapaDos	4	5,899
Error: Unable to get the OLEObjects property of the worksheet class Grant	by Tom Ogilvy	2	5,891
What is VB_Invoke_Func attribute? Jag Man	by Vegan55	1	5,773
[Excel 2010] how to get a horizontal scroll bar form control David	by David	2	5,761
Export Custom Form, .frx .frm files Chip Pearson	by Neal Zimm	1	5,727
Adding an image signature to an Email generated from VBA Raz Boyarski	by Draikonis	13	5,719
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	5,693
macro to disable auto refresh Patrick Bateman	by Jason[_6_]	12	5,648
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,544
Macro to copy to application MrPetreli	by Anwaar	3	5,517
Check how date is entered ( 1 2) [email protected]	by dpb	59	5,499
how to open visio file by Excel VBA moonhk[_2_]	by moonhk[_2_]	3	5,495
Macro To Change Column Headings Bob	by Bob	2	5,455
Print a Userform To Fit On One Page RyanH	by RyanH	3	5,424
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,420
How can I eliminate blinking scrollbars? Tony	by Jeff Nelson	5	5,178
Calculating Standard Deviation while ignoring Zeros [email protected]	by [email protected]	5	5,108
Dim c as Cell Keith Howard	by Legare	3	5,075
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,952
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,895
Copy multi-line variable to first empty row ( 1 2) Terry Pinnell[_4_]	by Terry Pinnell[_4_]	55	4,879
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	4,857
How to find the most common pair and triplet numbers? [email protected]	by Paul Black	25	4,821
Conditional formatting - based on indentation [email protected]	by Gary Keramidas	6	4,818
Excel 2007 VBA: Convert laaaaarge number to Hex nj	by Auric__	33	4,803
Excel VBA drawing Arcs programmatically - not lining up! Pat Russell	by Danny Chan	6	4,693