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,885
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	5,692
leading zeros using ActiveCell.Offset().value to insert row and value ( 1 2 3) TimLeonard	by Ron Rosenfeld[_2_]	87	6,302
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	7,718
Code looping through files ( 1 2) Otto Moehrbach	by rjr	66	3,248
Delete matching cells ( 1 2) gary	by Ron Rosenfeld[_2_]	66	4,191
Check how date is entered ( 1 2) [email protected]	by dpb	59	5,494
Issue with blanks and spaces ( 1 2) L. Howard	by Claus Busch	57	4,076
Worksheet sorting code/technique advise ( 1 2) Howard	by Howard	56	3,520
Copy multi-line variable to first empty row ( 1 2) Terry Pinnell[_4_]	by Terry Pinnell[_4_]	55	4,876
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,418
algorithm to INVERT a multiarea selection ? ( 1 2) keepITcool	by Myrna Larson	54	2,503
Read Dropdown list from Excel column ( 1 2) [email protected]	by GS[_2_]	51	4,120
How in to parse constants in formula to cells ( 1 2) [email protected]	by Ron Rosenfeld	51	3,665
Get a color name from any RGB combination? ( 1 2) Charlotte E.[_3_]	by GS[_2_]	50	4,237
Help with Mr. Peterson's Code.. Print serially from a Sheet ( 1 2) prkhan56	by Dave Peterson	50	2,937
delete record using Macro in excel spreed sheet ( 1 2) Lillian[_3_]	by Lillian[_5_]	47	2,955
More Excel 2007 Speed Issues ( 1 2) NormD	by KSR	47	3,315
Append One Array to Another, and Consolidate ( 1 2) Stratuser	by Alan Beban	47	2,777
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	9,433
Getting data from a closed wbook ( 1 2) Geoff K	by Geoff K	45	2,367
Code Count the items in a named range ( 1 2) L. Howard	by GS[_6_]	44	4,029
Bottom Up search for multiple entries ( 1 2) Hans Hamm	by Hans Hamm	44	4,282
Copy adjacent Sheet and name from a list ( 1 2) Howard	by Claus Busch	43	2,341
Conditional formatting ™£ ™¦ ™¥ ™* NT ( 1 2) Pierre62	by GS[_2_]	43	3,433
Align cells with same value - vba almost working ( 1 2) bpascal123	by pascal baro	43	4,015
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	4,855
Reduce duplicates to 1 with a count of how many before ( 1 2) L. Howard	by Claus Busch	42	2,487
Convert the date to day of the week. ( 1 2) Nils Titley	by Dave Peterson	41	1,491
Automatically Check Each Worksheet For Duplicate Entry ( 1 2) Hasan[_2_]	by Dave Peterson	40	1,303
Count of FIRST Digit Paul Black[_2_]	by Vasant Nanavati	39	1,046
how to detect host id of a computer using excel [email protected]	by WoolyBully	39	2,249
Remove Alpha Characters Minitman	by Ron Rosenfeld	39	1,192
Better protection for VBA project? Ron[_32_]	by ExcelBanter AI	37	8,777
Magic Excel function or UDF? Henrietta Horne	by Clif McIrvin[_3_]	37	1,423
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,266
For Each sheet in WkBook problem L. Howard	by L. Howard	36	1,934
Array instead of loop I'm sure L. Howard	by GS[_2_]	36	2,204
Is it Possible to create a Message Box (MSGBOX) with Excel Formula? Carlton	by Carlton Patterson	36	865
Maximum Number of times Jay	by Jay	36	816
My Never ending ARRAY code problems L. Howard	by Claus Busch	35	2,481
limiting characters in a cell abouassi	by Ken Johnson	35	1,010
Sorting Collection David	by Curt	35	1,031
I want to Split & save the data in different workbook Amol[_3_]	by T K[_2_]	35	1,308
Excel print object? Robert Baer	by GS[_6_]	35	3,804
Help Needed, May have bitten off more than I can chew Vacuum Sealed[_2_]	by Clif McIrvin[_3_]	35	1,408
Comparison of Time Max[_9_]	by TIMOTHY	34	3,322
List found strings on sheet L. Howard	by GS[_2_]	34	2,029
Formatting date as first letter of day only GavinS	by [email protected]	34	7,041
Adv Filter fails in macro, works manually --elizabeth	by Dave Peterson	34	940
A Boolean expression L. Howard	by L. Howard	34	2,610
Looking For A Formula qcan	by GS[_2_]	34	1,197
RowHeight and AutoFit wit Merged Cells Howard Kaikow	by Howard Kaikow	34	1,110
Complicated Time Formula Jay[_15_]	by Norman Harker	33	727
Frustrated with VBA so-called help davegb	by David McRitchie	33	858
Required Field for 7 Numeric digits only LRay67	by Rick Rothstein \(MVP - VB\)[_2029_]	33	927
Extracting word from phrase within column KH_GS[_2_]	by NickHK	33	881
Minimize Maximize buttons Scott	by Scott	33	922
Matching cells gcotterl[_2_]	by GS[_2_]	33	1,440
Excel 2007 VBA: Convert laaaaarge number to Hex nj	by Auric__	33	4,791
Randomly selecting a cell weighted on percentage mslabbe	by mslabbe	33	1,231
Function to read text file; find string; delete same before import [email protected]	by RB Smissaert	32	1,197
Clearing Immediate window in VBA by code Madiya	by Jim Rech[_2_]	32	1,436
trouble returning a workbook level Name object Brian Murphy	by Jan Karel Pieterse	32	1,111
combination of numbers in lottery knoertje[_6_]	by Tina	32	1,260
Randomize three variables subject to sum always equal to 1 emsfeld[_3_]	by Lars-Åke Aspelin	32	1,116
Extract Whole Row If Q Sean	by Dave Peterson	32	875
this code is VERY slow, is it the code or perhaps a worksheet issue Howard	by Howard	32	3,087
convert a Word macro to an Excel macro jsd219	by Dave Peterson	32	827
searching a large database with a long list of search terms [email protected]	by Roger Govier	32	1,063
Modify this Array TimLeonard	by simnamsinh	31	2,935
Removing Command Button Accesshelp	by Dave Peterson	31	959
Clear a "moving" range offset from Target L. Howard	by GS[_2_]	31	2,061
Loop Through Text and Test for Scenarios Q [email protected]	by [email protected]	31	1,555