Excel Programming - Page 601

Rating Thread / Thread Starter	Last Post	Replies	Views
Excel hangs EAB1977	by Clif McIrvin[_3_]	1	261
using the cells property for use with Application.WorksheetFunction.Sum EAB1977	by JLGWhiz[_2_]	2	324
Calendar Control 12.0 help EAB1977	by EAB1977	2	291
SetRange Help EAB1977	by EAB1977	4	295
Help with SetSourceData EAB1977	by Joel	1	223
Looping through a listbox EAB1977	by Bernie Deitrick	1	216
Help with Excel UserForm EAB1977	by Mike Fogleman[_2_]	2	251
ListView help EAB1977	by RB Smissaert	1	185
Command Button not responding EAB1977	by EAB1977	0	185
Access Coding Question EAB1977	by Kenneth Hobson[_3_]	2	287
Need help calculating time in VBA EAB1977	by Fred Smith[_4_]	1	381
Help with Filter and FilterOn EAB1977	by EAB1977	2	159
Help with MSCOMM control EAB1977	by EAB1977	0	208
Converting Text dates into dates EAB1977	by Gary''s Student	2	345
GetObject Error 429 - ActiveX control cannot create object EAB1977	by EAB1977	2	360
continue to move data until all moved eadie	by Ken Wright	11	363
vba code to sort data? eadie	by shockley	3	313
page break after eager beaver	by zackb	4	156
Creating a CommandBar - what's wrong? Eager2Learn	by Eager2Learn[_3_]	5	213
VB for copy & paste values (not formula's) Eager2Learn[_10_]	by mudraker[_274_]	1	227
Copy/Paste program error Eager2Learn[_11_]	by Eager2Learn[_12_]	2	213
Resizing Comment Box Eager2Learn[_13_]	by Bernie Deitrick	1	190
Edit Comment Box Eager2Learn[_14_]	by [email protected]	1	226
If ActiveSheet = .. then - I get an error Eager2Learn[_4_]	by Vasant Nanavati	2	223
Insert Row & copy all formulas - shared workbook Eager2Learn[_6_]	by keepITcool	1	427
Run Macro when Cell changes Eager2Learn[_7_]	by Eager2Learn[_9_]	5	187
how to make macro work even a sheet is hidden. EagerGit	by EagerGit	3	281
need help writing a script Hiding a range when a cell with in is greater than 53.. EagerGit	by Don Guillett[_2_]	1	177
Help needed editing a script EagerGit	by EagerGit	0	199
Help needed editing a script EagerGit	by joel[_903_]	1	166
Handling Dates in VLookup eager_beaver	by Bob Phillips[_6_]	21	656
Application.Displayalerts = value (is not working for me) [email protected]	by Dave Peterson[_5_]	3	461
How do I decrease the value of a column by 10% Eagledove	by Gord Dibben	5	1,429
VBA to center Selected Cell in Current Window [email protected]	by [email protected]	2	6,031
VBA code to ascertain difference between Range1 and Range2 [email protected]	by [email protected]	6	642
Correct VBA for DO WHILE i.e. X=X AND NOT RS.EOF [email protected]	by [email protected]	3	942
VBA Editor Window(s) size challenge [email protected]	by Dave Peterson	9	416
Help with PROPERTY GET [email protected]	by [email protected]	7	234
"String" manipulation for a Case clause [email protected]	by [email protected]	28	1,645
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value ) ,"OK","No Match) [email protected]	by [email protected]	2	305
How to code ReDim Preserve when "ReDim strArr(1 To 100, 1 To 3)" [email protected]	by [email protected]	10	699
Matching/Finding/Search Array Element [email protected]	by [email protected]	8	365
Help with Replace() [email protected]	by [email protected]	11	539
How to obtain Cell Address and/or Select all sheet-cells with xlExcelLinks [email protected]	by Barb Reinhardt	1	270
Process steps to compile current VBA macros into a DLL or COM Addin [email protected]	by Joel	1	299
VBA Syntax for Countif condition where only 1st char in Range of each cell = "M" [email protected]	by [email protected]	5	398
Desire ChangeEvent not triggered if ChangeEvent was column (field) insertion [email protected]	by Dave Peterson	10	443
Help with Traping (I believe) a no-Find() error throuh the us of a seemingly unrelated functiom [email protected]	by Dave Peterson	9	299
Execute a variable as an insertion into a VBA code line [email protected]	by Chip Pearson	7	344
Error proof way to find first blank Row after Autofilter Range [email protected]	by [email protected]	6	218
How in to parse constants in formula to cells ( 1 2) [email protected]	by Ron Rosenfeld	51	3,719
How to Parse a string; Delimiter is any Operator [email protected]	by [email protected]	25	691
How to test success of a "Set" command? [email protected]	by [email protected]	2	185
Work-around for lack of " ' " before/after sheet names with no spaces [email protected]	by [email protected]	8	226
Syntax to stop code in Watch Window [email protected]	by Dave Miller	9	413
VBA code syntax vs XL Conditional Formatting & Watch Window [email protected]	by OssieMac	1	201
Best position in VBA code line for [email protected]	by Dave Peterson	7	260
Most efficient code to "flip" a range of values + vs - [email protected]	by Roger Govier	8	286
How to turn on the pop-up "alternatives" while editing in the VBA Editor [email protected]	by [email protected]	5	364
Why need to use Selection.PasteSpecial vs myRange.PasteSpecial [email protected]	by [email protected]	4	245
How to obtain the Row number of next visible cell Down? [email protected]	by [email protected]	7	258
How to obtain cell address of a succesful VLookup? [email protected]	by [email protected]	8	246
VBA to acsertain if last w/s change was "insert Row" [email protected]	by Gary''s Student	8	415
VBA (or Excel) crashes if Count of Visible Rows in Autofilter Range = 1 [email protected]	by [email protected]	2	372
Resize Sumif formula parameters for added data [email protected]	by [email protected]	5	397
Activate Sheet Best Practice (Y/N?) when xFer data between sheets? [email protected]	by [email protected]	2	384
Match() how to workaround identical Lookup_values [email protected]	by [email protected]	0	190
Why R1C1 range parameters in VBA Pivot Table setup/ [email protected]	by [email protected]	18	1,828
Pivot Table Creation Macro fails with Error #5 "Invalid procedure call or argument" [email protected]	by [email protected]	1	624
Function to read text file; find string; delete same before import [email protected]	by RB Smissaert	32	1,198
How to avoid Compatibility Checker MsgBox? VBA to avoid or prevent? [email protected]	by [email protected]	1	360
VBA for worksheet change (add row) event (I think) [email protected]	by [email protected]	1	394
How to extend the life of a variable from one Private Sub routine to another? [email protected]	by [email protected]	2	179
To use AppSentinel to set-up XL Macro for a dll; still need VBA 6.0? [email protected]	by [email protected]	2	217
VBA code to format only the cells added in a new row insertion [email protected]	by OssieMac	3	162