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,889
PLEASE READ IF YOU PROGRAM: Help Continue Visual Basic ( 1 2 3) Harlan Grove	by [email protected]	104	5,701
leading zeros using ActiveCell.Offset().value to insert row and value ( 1 2 3) TimLeonard	by Ron Rosenfeld[_2_]	87	6,306
Read (and parse) file on the web ( 1 2 3) Auric__	by Robert Baer	87	7,746
Code looping through files ( 1 2) Otto Moehrbach	by rjr	66	3,278
Delete matching cells ( 1 2) gary	by Ron Rosenfeld[_2_]	66	4,197
Check how date is entered ( 1 2) [email protected]	by dpb	59	5,503
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,524
Copy multi-line variable to first empty row ( 1 2) Terry Pinnell[_4_]	by Terry Pinnell[_4_]	55	4,885
Excel and the Math Coprocessor for DLLs ( 1 2) Lynn McGuire[_2_]	by joeu2004[_2_]	54	5,421
algorithm to INVERT a multiarea selection ? ( 1 2) keepITcool	by Myrna Larson	54	2,508
Read Dropdown list from Excel column ( 1 2) [email protected]	by GS[_2_]	51	4,137
How in to parse constants in formula to cells ( 1 2) [email protected]	by Ron Rosenfeld	51	3,667
Get a color name from any RGB combination? ( 1 2) Charlotte E.[_3_]	by GS[_2_]	50	4,239
Help with Mr. Peterson's Code.. Print serially from a Sheet ( 1 2) prkhan56	by Dave Peterson	50	2,964
delete record using Macro in excel spreed sheet ( 1 2) Lillian[_3_]	by Lillian[_5_]	47	2,956
More Excel 2007 Speed Issues ( 1 2) NormD	by KSR	47	3,317
Append One Array to Another, and Consolidate ( 1 2) Stratuser	by Alan Beban	47	2,779
IP address to Hostname in Excel ( 1 2) nicktruman	by ExcelBanter AI	45	9,529
Getting data from a closed wbook ( 1 2) Geoff K	by Geoff K	45	2,373
Code Count the items in a named range ( 1 2) L. Howard	by GS[_6_]	44	4,031
Bottom Up search for multiple entries ( 1 2) Hans Hamm	by Hans Hamm	44	4,325
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,440
Align cells with same value - vba almost working ( 1 2) bpascal123	by pascal baro	43	4,024
Macro to generate powerpoint slides ( 1 2) Marty Girvan	by Marty Girvan	43	4,857
Reduce duplicates to 1 with a count of how many before ( 1 2) L. Howard	by Claus Busch	42	2,488
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,791
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,267
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,482
limiting characters in a cell abouassi	by Ken Johnson	35	1,011
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,308
Excel print object? Robert Baer	by GS[_6_]	35	3,816
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,327
List found strings on sheet L. Howard	by GS[_2_]	34	2,031
Formatting date as first letter of day only GavinS	by [email protected]	34	7,052
Adv Filter fails in macro, works manually --elizabeth	by Dave Peterson	34	941
A Boolean expression L. Howard	by L. Howard	34	2,612
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	884
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,822
Randomly selecting a cell weighted on percentage mslabbe	by mslabbe	33	1,237
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,441
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,063
Loop Through Text and Test for Scenarios Q [email protected]	by [email protected]	31	1,555