Excel Programming - ExcelBanter

Rating Thread / Thread Starter	Last Post	Replies	Views
Rusty at excel, could use a hand with a macro Megz	by Megz	1	771
looking for any summary formulation program driller3_banter	by driller3_banter	0	1,809
concatenate a range of data jt	by Wilbur Chua	5	1,009
Stoplight indicators in Excel K. Trotter	by johnbarrel	6	746
exel xlsm - line argument for automatic allow modify and contents Pierpaolo Sasia	by Pierpaolo Sasia	0	329
Formula to determine the number of work hours per month sicelo matambo	by Claus Busch	1	244
adding if then statement in the formula below sicelo matambo	by sicelo matambo	0	190
VBA delete certain cell contents if condition is met Sabosis	by Sabosis	0	183
@ operator inconsistency in VBA .formula StuartBisset	by Peter T[_8_]	1	432
Save file with date from cell Sabosis	by Peter T[_8_]	2	241
Undo all changes Tatsujin	by Lynn McGuire[_3_]	1	348
Delete range with formatting Tatsujin	by Tatsujin	0	208
Activate the cell which was found by vlookup formula Norbert[_4_]	by Norbert[_4_]	13	967
How to suppress a message box from popping up during a macro Norbert[_4_]	by Norbert[_4_]	6	640
Date conversion programmernovice[_2_]	by programmernovice[_2_]	2	201
Trapping an Excel crash upsidedownhouse	by Peter T[_8_]	1	662
Creating track on map from position data Jesper Kaas	by Jesper Kaas	0	243
Rich text box control Tatsujin	by Adrian Caspersz	1	1,218
Activex component cannot create object Excel 365 for mac lamar spalding	by Peter T[_8_]	2	842
Overflow error Tatsujin	by Peter T[_8_]	1	316
Extract text from text string john taiariol	by john taiariol	6	291
Extract segments of an array Tatsujin	by dpb	10	900
Multi-column listbox help Tatsujin	by Tatsujin	2	332
Insert into presorted list Tatsujin	by Tatsujin	2	233
Split up or delineate data Tatsujin	by Claus Busch	5	251
Listbox with dynamic strings Tatsujin	by Peter T[_8_]	1	341
VBA Script for Radio Button programmernovice[_2_]	by programmernovice[_2_]	3	241
Compare two Columns , and if is it a Match , copy Xxer Xxes	by Xxer Xxes	6	674
Changing workbook name in named cell programmernovice[_2_]	by programmernovice[_2_]	2	305
Path string has spaces Tatsujin	by Tatsujin	2	231
Worksheet_BeforeDoubleClick subtract sum of cells below top cell Dave[_85_]	by Peter T[_8_]	9	453
Handle keyboard events Tatsujin	by Peter T[_8_]	1	252
Converting Numeral to Time equivalent NoodNutt[_2_]	by jerry_maguire	13	1,198
VBA JJG	by jerry_maguire	8	364
Eliminate duplicate words from string Tatsujin	by jerry_maguire	4	308
Need a UDF to count blank cells ytayta555	by jerry_maguire	10	1,076
Problem with hlookup formula Norbert[_4_]	by jerry_maguire	18	1,788
Path/File access error: '.\VB??.tmp' Daniel Debes	by Thanh SÆ¡n Cao	3	1,755
Avoid ,,Select" and ,,Selection" in a few lines of code Xxer Xxes	by Xxer Xxes	5	393
CRviewer14.dll - Crystal repotrs wiht VBA JJG	by JJG	0	306
Copy paste different size problem Dorel Eugen	by Xxer Xxes	12	1,027
VBA Does not recognize cell contents programmernovice[_2_]	by Jesper Kaas	5	289
Help with named-cell referencing programmernovice[_2_]	by programmernovice[_2_]	2	274
IP address to Hostname in Excel ( 1 2) nicktruman	by Andrey G	44	7,462
Script Runner Pro Indra Dwi Santoso	by emaillist	1	1,018
Step() Function programmernovice[_2_]	by programmernovice[_2_]	2	338
Why this tooltip works ? Emilio[_3_]	by Peter T[_8_]	1	315
Converting a Number to Time NoodNutt[_2_]	by NoodNutt[_2_]	0	254
Deleting rows when Worksheet_Change active NoodNutt[_2_]	by NoodNutt[_2_]	3	287
Moving a number programmernovice[_2_]	by programmernovice[_2_]	7	286
how to error-check text box values Michael Soyka	by Michael Soyka	4	343
UserForm triggers File Corruption NoodNutt[_2_]	by NoodNutt[_2_]	1	292
Enabling/Disabling ActiveX Command Buttons NoodNutt[_2_]	by NoodNutt[_2_]	4	311
File Extension NoodNutt[_2_]	by NoodNutt[_2_]	1	230
Express Array Function as VB NoodNutt[_2_]	by NoodNutt[_2_]	3	228
Converting three calculators in a workbook into one with a dropdown box (hardcoded) TheJay	by TheJay	0	269
Copy paste in last row TIMOTHY	by TIMOTHY	0	196
VBA for Selecting Last Row in Range David Godinger[_2_]	by David Godinger[_2_]	10	905
Identifying PERSONAL.XLSB macros [email protected]	by Peter T[_8_]	4	209
X Y Scatter Excel Graph X Axis Customization Max[_9_]	by Max[_9_]	14	1,263
Help pasing cell reference to user-defined VBA function [email protected]	by [email protected]	2	239
Coordinates of a grouped line David Cuthill[_3_]	by David Cuthill[_3_]	2	263
Excel VSTO: Selecting range according to properties JDias	by JDias	1	777
Determine the end coordinates of an Arc and then add textbox David Cuthill[_3_]	by Peter T[_8_]	9	414
Adding code behind newly created chartsheet - subscript out of range David Cuthill[_3_]	by David Cuthill[_3_]	1	379
Skipping sheets when copying Jan Kronsell[_6_]	by Jan Kronsell[_6_]	2	360
Syntax? dpb	by Claus Busch	5	385
Array formula for lookup a max value cost too much time [email protected]	by Claus Busch	5	253
Mark the first Unique Record in a list with VBA [email protected]	by [email protected]	2	332
Select identical column/rows based on the active cell and copy datato another sheet [email protected]	by [email protected]	5	468
Reserve the Horizontal line numbers and information , but the calculation result is c wk3913	by wk3913	0	221
VBA project does not close when workbook is closed SimonN	by [email protected]	5	2,835
Can I put buttons on a sheet without selecting? Don Wiss	by Don Wiss	1	320
Regular expression problem RG III	by Adrian Caspersz	1	413
not sure but think sumif problem Phillip Swanepoel	by Phillip Swanepoel	3	237