Excel Programming - ExcelBanter

Rating Thread / Thread Starter	Last Post	Replies	Views
tickler for date + 180 days ram1000	by ExcelBanter AI	3	50,170
Pi in VBA? Prof Wonmug	by ExcelBanter AI	29	48,016
where is References dialog box? Philip Reece-Heal[_3_]	by ExcelBanter AI	4	28,640
Excel 2007 User form Enter Data Last Row @Table Debbie D.	by ExcelBanter AI	2	28,243
convert percentage to text zhj23	by ExcelBanter AI	9	22,098
How to Select A Cell in VBA with a Variable Row Number? David Godinger[_2_]	by ExcelBanter AI	4	18,913
How to add a calendar object to Excel 2010? hannu	by ExcelBanter AI	4	18,685
Removing vowels from words... [email protected]	by ExcelBanter AI	16	16,775
Margin of Error Formula Heather Rabbitt	by ExcelBanter AI	6	16,434
Calculate phases of the moon Chuck[_11_]	by ExcelBanter AI	13	16,262
Calculating Winning Percentages seme	by ExcelBanter AI	3	13,099
Querytables refresh gives Subscript out of Range Error Fid[_2_]	by ExcelBanter AI	1	12,744
Mod 43 Check Digit calculator CLI-Art	by ExcelBanter AI	16	12,230
VBA code to find first blank cell in a column and activate it Wes_A[_2_]	by ExcelBanter AI	5	11,626
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	10,689
How to set multiple columns in "If Target.Column =" Brad K.	by ExcelBanter AI	4	9,933
Mid-Month function help Matthew Dyer	by ExcelBanter AI	6	9,817
WorksheetFunction.Left problem LuisE	by ExcelBanter AI	4	9,809
vba - Select Used Range minus the top header Johnny[_11_]	by ExcelBanter AI	5	9,782
Convert Date/time to date only in vba Jonathan	by ExcelBanter AI	4	9,600
deselecting a highlighted range after a VBA copy procedure Paul James[_3_]	by ExcelBanter AI	6	9,141
Lehman formula Dr. Mark W. Lee	by ExcelBanter AI	6	9,064
Add comment to command button Learn-more	by ExcelBanter AI	10	9,061
Better protection for VBA project? Ron[_32_]	by ExcelBanter AI	37	9,048
Convert Base 36 to base 10 David	by ExcelBanter AI	18	8,905
How to Use Relative Reference in Array Formula [email protected]	by ExcelBanter AI	5	8,601
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	8,516
formula for aquiring a gestational age Scott	by ExcelBanter AI	4	8,367
Testing to find if UserForm is Loaded DanB	by ExcelBanter AI	7	8,145
Null date in VBA variable Den	by ExcelBanter AI	5	8,071
xlDialogPrint arguments TWR	by ExcelBanter AI	3	8,066
List all combinations of 6/36 with unique 4 numbers Martin-888	by ExcelBanter AI	27	8,055
Array multiplication in VBA Dan E[_3_]	by Tom Ogilvy	10	7,743
Excel Math Bug ( 1 2 3 ... Last Page) fred	by Phil Carmody	170	7,695
Formatting date as first letter of day only GavinS	by [email protected]	34	7,187
Is there any way to collapse/expand codes in VBA editor? iop	by Bob Phillips	3	6,868
loop each with each string obar2	by RB Smissaert	16	6,689
leading zeros using ActiveCell.Offset().value to insert row and value ( 1 2 3) TimLeonard	by Ron Rosenfeld[_2_]	87	6,620
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed Marcin[_2_]	by GS[_2_]	15	6,458
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	6,303
Unable to set the LeftHeader property of the PageSetup class John[_140_]	by James[_44_]	7	6,294
How to start an RDP seesion by clicking link. Michael	by Michael	6	6,234
VBA to center Selected Cell in Current Window [email protected]	by [email protected]	2	6,135
The Microsoft Jet database engine could not find the object 'Sheet Stu[_35_]	by kumaresh_81	7	6,119
What formula converts mpg to l/100km Russ	by PapaDos	4	6,092
Error: Unable to get the OLEObjects property of the worksheet class Grant	by Tom Ogilvy	2	6,042
Check how date is entered ( 1 2) [email protected]	by dpb	59	6,022
Using excel to Determine if a File Exists in SharePoint ryguy7272	by ryguy7272	11	6,014
What is VB_Invoke_Func attribute? Jag Man	by Vegan55	1	6,009
Adding an image signature to an Email generated from VBA Raz Boyarski	by Draikonis	13	5,839
[Excel 2010] how to get a horizontal scroll bar form control David	by David	2	5,835
Export Custom Form, .frx .frm files Chip Pearson	by Neal Zimm	1	5,824
macro to disable auto refresh Patrick Bateman	by Jason[_6_]	12	5,818
VBA project duplicated in Project Explorer teabag	by blocked	11	5,709
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,685
Run Macro on All Sheets Q [email protected]	by GS[_2_]	8	5,666
Macro to copy to application MrPetreli	by Anwaar	3	5,621
how to open visio file by Excel VBA moonhk[_2_]	by moonhk[_2_]	3	5,606
Print a Userform To Fit On One Page RyanH	by RyanH	3	5,589
Macro To Change Column Headings Bob	by Bob	2	5,530
Copy multi-line variable to first empty row ( 1 2) Terry Pinnell[_4_]	by Terry Pinnell[_4_]	55	5,354
How can I eliminate blinking scrollbars? Tony	by Jeff Nelson	5	5,320
Calculating Standard Deviation while ignoring Zeros [email protected]	by [email protected]	5	5,198
Dim c as Cell Keith Howard	by Legare	3	5,190
adding subtracting angles/degrees Jimmy	by Jimmy	3	5,189
What do these characters mean? sebastienm	by sebastienm	0	5,112
Error Message regarding .TextFilePlatform = 437 Sue	by Sue	3	5,050
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	5,022
I need to use CreateObject("OracleInProcServer.XOraSession") Falango	by Falango	2	5,016
Loop Until Last Worksheet in Workbook [email protected]	by [email protected]	2	4,989
Conditional formatting - based on indentation [email protected]	by Gary Keramidas	6	4,986
Excel 2007 VBA: Convert laaaaarge number to Hex nj	by Auric__	33	4,984
VBA Floor/Celing commands BOHICA	by Vic Eldridge	3	4,970
Excel VBA drawing Arcs programmatically - not lining up! Pat Russell	by Danny Chan	6	4,953
How to find the most common pair and triplet numbers? [email protected]	by Paul Black	25	4,899