Excel Programming - ExcelBanter

Rating Thread / Thread Starter	Last Post	Replies	Views
tickler for date + 180 days ram1000	by ExcelBanter AI	3	49,960
Pi in VBA? Prof Wonmug	by ExcelBanter AI	29	47,552
where is References dialog box? Philip Reece-Heal[_3_]	by ExcelBanter AI	4	28,322
Excel 2007 User form Enter Data Last Row @Table Debbie D.	by ExcelBanter AI	2	28,009
convert percentage to text zhj23	by ExcelBanter AI	9	21,738
How to Select A Cell in VBA with a Variable Row Number? David Godinger[_2_]	by ExcelBanter AI	4	18,599
How to add a calendar object to Excel 2010? hannu	by ExcelBanter AI	4	18,466
Margin of Error Formula Heather Rabbitt	by ExcelBanter AI	6	16,188
Calculate phases of the moon Chuck[_11_]	by ExcelBanter AI	13	15,886
Removing vowels from words... [email protected]	by ExcelBanter AI	16	15,807
Calculating Winning Percentages seme	by ExcelBanter AI	3	12,777
Querytables refresh gives Subscript out of Range Error Fid[_2_]	by ExcelBanter AI	1	12,531
Mod 43 Check Digit calculator CLI-Art	by ExcelBanter AI	16	11,698
VBA code to find first blank cell in a column and activate it Wes_A[_2_]	by ExcelBanter AI	5	11,398
How to set multiple columns in "If Target.Column =" Brad K.	by ExcelBanter AI	4	9,585
WorksheetFunction.Left problem LuisE	by ExcelBanter AI	4	9,570
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	9,521
vba - Select Used Range minus the top header Johnny[_11_]	by ExcelBanter AI	5	9,521
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,889
Better protection for VBA project? Ron[_32_]	by ExcelBanter AI	37	8,789
Add comment to command button Learn-more	by ExcelBanter AI	10	8,721
Lehman formula Dr. Mark W. Lee	by ExcelBanter AI	6	8,541
Convert Base 36 to base 10 David	by ExcelBanter AI	18	8,489
How to Use Relative Reference in Array Formula [email protected]	by ExcelBanter AI	5	8,344
Convert Date/time to date only in vba Jonathan	by ExcelBanter AI	4	8,308
formula for aquiring a gestational age Scott	by ExcelBanter AI	4	7,982
Testing to find if UserForm is Loaded DanB	by ExcelBanter AI	7	7,769
xlDialogPrint arguments TWR	by ExcelBanter AI	3	7,753
List all combinations of 6/36 with unique 4 numbers Martin-888	by ExcelBanter AI	27	7,753
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	7,744
Null date in VBA variable Den	by ExcelBanter AI	5	7,665
Array multiplication in VBA Dan E[_3_]	by Tom Ogilvy	10	7,496
Formatting date as first letter of day only GavinS	by [email protected]	34	7,052
Excel Math Bug ( 1 2 3 ... Last Page) fred	by Phil Carmody	170	6,889
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,306
Unable to set the LeftHeader property of the PageSetup class John[_140_]	by James[_44_]	7	6,221
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,023
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,902
Error: Unable to get the OLEObjects property of the worksheet class Grant	by Tom Ogilvy	2	5,899
What is VB_Invoke_Func attribute? Jag Man	by Vegan55	1	5,775
[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,731
Adding an image signature to an Email generated from VBA Raz Boyarski	by Draikonis	13	5,728
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	5,701
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,602
VBA project duplicated in Project Explorer teabag	by blocked	11	5,545
Macro to copy to application MrPetreli	by Anwaar	3	5,522
Check how date is entered ( 1 2) [email protected]	by dpb	59	5,502
how to open visio file by Excel VBA moonhk[_2_]	by moonhk[_2_]	3	5,500
Macro To Change Column Headings Bob	by Bob	2	5,456
Print a Userform To Fit On One Page RyanH	by RyanH	3	5,431
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,421
How can I eliminate blinking scrollbars? Tony	by Jeff Nelson	5	5,181
Calculating Standard Deviation while ignoring Zeros [email protected]	by [email protected]	5	5,108
Dim c as Cell Keith Howard	by Legare	3	5,076
adding subtracting angles/degrees Jimmy	by Jimmy	3	5,064
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,883
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	4,857
Conditional formatting - based on indentation [email protected]	by Gary Keramidas	6	4,826
How to find the most common pair and triplet numbers? [email protected]	by Paul Black	25	4,821
Excel 2007 VBA: Convert laaaaarge number to Hex nj	by Auric__	33	4,820
Excel VBA drawing Arcs programmatically - not lining up! Pat Russell	by Danny Chan	6	4,695