Excel Programming - ExcelBanter

Rating Thread / Thread Starter	Last Post	Replies	Views
Excel Math Bug ( 1 2 3 ... Last Page) fred	by Phil Carmody	170	6,898
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	5,709
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	7,768
leading zeros using ActiveCell.Offset().value to insert row and value ( 1 2 3) TimLeonard	by Ron Rosenfeld[_2_]	87	6,312
Delete matching cells ( 1 2) gary	by Ron Rosenfeld[_2_]	66	4,204
Code looping through files ( 1 2) Otto Moehrbach	by rjr	66	3,280
Check how date is entered ( 1 2) [email protected]	by dpb	59	5,513
Issue with blanks and spaces ( 1 2) L. Howard	by Claus Busch	57	4,080
Worksheet sorting code/technique advise ( 1 2) Howard	by Howard	56	3,527
Copy multi-line variable to first empty row ( 1 2) Terry Pinnell[_4_]	by Terry Pinnell[_4_]	55	4,897
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,427
algorithm to INVERT a multiarea selection ? ( 1 2) keepITcool	by Myrna Larson	54	2,513
Read Dropdown list from Excel column ( 1 2) [email protected]	by GS[_2_]	51	4,145
How in to parse constants in formula to cells ( 1 2) [email protected]	by Ron Rosenfeld	51	3,713
Help with Mr. Peterson's Code.. Print serially from a Sheet ( 1 2) prkhan56	by Dave Peterson	50	2,986
Get a color name from any RGB combination? ( 1 2) Charlotte E.[_3_]	by GS[_2_]	50	4,245
delete record using Macro in excel spreed sheet ( 1 2) Lillian[_3_]	by Lillian[_5_]	47	2,965
More Excel 2007 Speed Issues ( 1 2) NormD	by KSR	47	3,320
Append One Array to Another, and Consolidate ( 1 2) Stratuser	by Alan Beban	47	2,784
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	9,654
Getting data from a closed wbook ( 1 2) Geoff K	by Geoff K	45	2,374
Code Count the items in a named range ( 1 2) L. Howard	by GS[_6_]	44	4,042
Bottom Up search for multiple entries ( 1 2) Hans Hamm	by Hans Hamm	44	4,326
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	4,862
Align cells with same value - vba almost working ( 1 2) bpascal123	by pascal baro	43	4,054
Conditional formatting ™£ ™¦ ™¥ ™* NT ( 1 2) Pierre62	by GS[_2_]	43	3,440
Copy adjacent Sheet and name from a list ( 1 2) Howard	by Claus Busch	43	2,342
Reduce duplicates to 1 with a count of how many before ( 1 2) L. Howard	by Claus Busch	42	2,493
Convert the date to day of the week. ( 1 2) Nils Titley	by Dave Peterson	41	1,493
Automatically Check Each Worksheet For Duplicate Entry ( 1 2) Hasan[_2_]	by Dave Peterson	40	1,306
Count of FIRST Digit Paul Black[_2_]	by Vasant Nanavati	39	1,047
how to detect host id of a computer using excel [email protected]	by WoolyBully	39	2,251
Remove Alpha Characters Minitman	by Ron Rosenfeld	39	1,193
Identify Hidden Columns Steve[_4_]	by Charabeuh[_6_]	37	1,220
using a worksheet range to populate a combo box in excel Kev[_7_]	by Superman	37	1,270
Better protection for VBA project? Ron[_32_]	by ExcelBanter AI	37	8,796
Magic Excel function or UDF? Henrietta Horne	by Clif McIrvin[_3_]	37	1,423
Is it Possible to create a Message Box (MSGBOX) with Excel Formula? Carlton	by Carlton Patterson	36	865
For Each sheet in WkBook problem L. Howard	by L. Howard	36	1,935
Array instead of loop I'm sure L. Howard	by GS[_2_]	36	2,206
Maximum Number of times Jay	by Jay	36	817
Excel print object? Robert Baer	by GS[_6_]	35	3,833
My Never ending ARRAY code problems L. Howard	by Claus Busch	35	2,483
Help Needed, May have bitten off more than I can chew Vacuum Sealed[_2_]	by Clif McIrvin[_3_]	35	1,409
limiting characters in a cell abouassi	by Ken Johnson	35	1,012
Sorting Collection David	by Curt	35	1,032
I want to Split & save the data in different workbook Amol[_3_]	by T K[_2_]	35	1,310
Formatting date as first letter of day only GavinS	by [email protected]	34	7,057
Adv Filter fails in macro, works manually --elizabeth	by Dave Peterson	34	941
Comparison of Time Max[_9_]	by TIMOTHY	34	3,335
Looking For A Formula qcan	by GS[_2_]	34	1,198
RowHeight and AutoFit wit Merged Cells Howard Kaikow	by Howard Kaikow	34	1,111
A Boolean expression L. Howard	by L. Howard	34	2,615
List found strings on sheet L. Howard	by GS[_2_]	34	2,034
Complicated Time Formula Jay[_15_]	by Norman Harker	33	728
Frustrated with VBA so-called help davegb	by David McRitchie	33	859
Extracting word from phrase within column KH_GS[_2_]	by NickHK	33	885
Minimize Maximize buttons Scott	by Scott	33	923
Randomly selecting a cell weighted on percentage mslabbe	by mslabbe	33	1,238
Required Field for 7 Numeric digits only LRay67	by Rick Rothstein \(MVP - VB\)[_2029_]	33	928
Excel 2007 VBA: Convert laaaaarge number to Hex nj	by Auric__	33	4,890
Matching cells gcotterl[_2_]	by GS[_2_]	33	1,442
convert a Word macro to an Excel macro jsd219	by Dave Peterson	32	828
Extract Whole Row If Q Sean	by Dave Peterson	32	875
Clearing Immediate window in VBA by code Madiya	by Jim Rech[_2_]	32	1,445
this code is VERY slow, is it the code or perhaps a worksheet issue Howard	by Howard	32	3,087
searching a large database with a long list of search terms [email protected]	by Roger Govier	32	1,064
Function to read text file; find string; delete same before import [email protected]	by RB Smissaert	32	1,197
Randomize three variables subject to sum always equal to 1 emsfeld[_3_]	by Lars-Åke Aspelin	32	1,117
combination of numbers in lottery knoertje[_6_]	by Tina	32	1,261
trouble returning a workbook level Name object Brian Murphy	by Jan Karel Pieterse	32	1,112
Page break macro Susan	by Susan	31	824
Loop Through Text and Test for Scenarios Q [email protected]	by [email protected]	31	1,556
Array Problem Jonas[_3_]	by Peter T	31	870
Extreme calculations Diogo	by Diogo	31	1,055