Excel Programming - ExcelBanter

Rating Thread / Thread Starter	Last Post	Replies	Views
tickler for date + 180 days ram1000	by ExcelBanter AI	3	49,962
Pi in VBA? Prof Wonmug	by ExcelBanter AI	29	47,557
where is References dialog box? Philip Reece-Heal[_3_]	by ExcelBanter AI	4	28,330
Excel 2007 User form Enter Data Last Row @Table Debbie D.	by ExcelBanter AI	2	28,011
convert percentage to text zhj23	by ExcelBanter AI	9	21,745
How to Select A Cell in VBA with a Variable Row Number? David Godinger[_2_]	by ExcelBanter AI	4	18,606
How to add a calendar object to Excel 2010? hannu	by ExcelBanter AI	4	18,468
Margin of Error Formula Heather Rabbitt	by ExcelBanter AI	6	16,192
Calculate phases of the moon Chuck[_11_]	by ExcelBanter AI	13	15,895
Removing vowels from words... [email protected]	by ExcelBanter AI	16	15,829
Calculating Winning Percentages seme	by ExcelBanter AI	3	12,781
Querytables refresh gives Subscript out of Range Error Fid[_2_]	by ExcelBanter AI	1	12,536
Mod 43 Check Digit calculator CLI-Art	by ExcelBanter AI	16	11,706
VBA code to find first blank cell in a column and activate it Wes_A[_2_]	by ExcelBanter AI	5	11,400
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	9,632
How to set multiple columns in "If Target.Column =" Brad K.	by ExcelBanter AI	4	9,597
WorksheetFunction.Left problem LuisE	by ExcelBanter AI	4	9,570
vba - Select Used Range minus the top header Johnny[_11_]	by ExcelBanter AI	5	9,522
Mid-Month function help Matthew Dyer	by ExcelBanter AI	6	9,488
deselecting a highlighted range after a VBA copy procedure Paul James[_3_]	by ExcelBanter AI	6	8,895
Better protection for VBA project? Ron[_32_]	by ExcelBanter AI	37	8,796
Add comment to command button Learn-more	by ExcelBanter AI	10	8,734
Lehman formula Dr. Mark W. Lee	by ExcelBanter AI	6	8,555
Convert Base 36 to base 10 David	by ExcelBanter AI	18	8,504
How to Use Relative Reference in Array Formula [email protected]	by ExcelBanter AI	5	8,346
Convert Date/time to date only in vba Jonathan	by ExcelBanter AI	4	8,321
formula for aquiring a gestational age Scott	by ExcelBanter AI	4	7,989
Testing to find if UserForm is Loaded DanB	by ExcelBanter AI	7	7,774
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	7,762
xlDialogPrint arguments TWR	by ExcelBanter AI	3	7,762
List all combinations of 6/36 with unique 4 numbers Martin-888	by ExcelBanter AI	27	7,761
Null date in VBA variable Den	by ExcelBanter AI	5	7,673
Array multiplication in VBA Dan E[_3_]	by Tom Ogilvy	10	7,499
Formatting date as first letter of day only GavinS	by [email protected]	34	7,055
Excel Math Bug ( 1 2 3 ... Last Page) fred	by Phil Carmody	170	6,891
Is there any way to collapse/expand codes in VBA editor? iop	by Bob Phillips	3	6,813
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,312
Unable to set the LeftHeader property of the PageSetup class John[_140_]	by James[_44_]	7	6,224
How to start an RDP seesion by clicking link. Michael	by Michael	6	6,170
The Microsoft Jet database engine could not find the object 'Sheet Stu[_35_]	by kumaresh_81	7	6,052
VBA to center Selected Cell in Current Window [email protected]	by [email protected]	2	6,029
Using excel to Determine if a File Exists in SharePoint ryguy7272	by ryguy7272	11	5,941
Error: Unable to get the OLEObjects property of the worksheet class Grant	by Tom Ogilvy	2	5,911
What formula converts mpg to l/100km Russ	by PapaDos	4	5,908
What is VB_Invoke_Func attribute? Jag Man	by Vegan55	1	5,787
[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,735
Adding an image signature to an Email generated from VBA Raz Boyarski	by Draikonis	13	5,729
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	5,704
macro to disable auto refresh Patrick Bateman	by Jason[_6_]	12	5,655
Run Macro on All Sheets Q [email protected]	by GS[_2_]	8	5,603
VBA project duplicated in Project Explorer teabag	by blocked	11	5,545
Macro to copy to application MrPetreli	by Anwaar	3	5,526
Check how date is entered ( 1 2) [email protected]	by dpb	59	5,513
how to open visio file by Excel VBA moonhk[_2_]	by moonhk[_2_]	3	5,501
Macro To Change Column Headings Bob	by Bob	2	5,456
Print a Userform To Fit On One Page RyanH	by RyanH	3	5,432
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,424
How can I eliminate blinking scrollbars? Tony	by Jeff Nelson	5	5,182
Calculating Standard Deviation while ignoring Zeros [email protected]	by [email protected]	5	5,111
Dim c as Cell Keith Howard	by Legare	3	5,080
adding subtracting angles/degrees Jimmy	by Jimmy	3	5,067
What do these characters mean? sebastienm	by sebastienm	0	5,046
Error Message regarding .TextFilePlatform = 437 Sue	by Sue	3	4,954
I need to use CreateObject("OracleInProcServer.XOraSession") Falango	by Falango	2	4,913
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,892
Excel 2007 VBA: Convert laaaaarge number to Hex nj	by Auric__	33	4,882
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	4,859
Conditional formatting - based on indentation [email protected]	by Gary Keramidas	6	4,830
How to find the most common pair and triplet numbers? [email protected]	by Paul Black	25	4,821
Excel VBA drawing Arcs programmatically - not lining up! Pat Russell	by Danny Chan	6	4,704