Excel Programming - Page 19

Rating Thread / Thread Starter	Last Post	Replies	Views
Excel Spreadsheet-Salutation Column Pam	by Otto Moehrbach[_6_]	1	1,196
Runtime error 1004: Select method of worksheet class failed chuckm	by chuckm	3	1,196
OnAction Cannot find Macro ?? Andrew Kennard	by Bob Phillips[_6_]	5	1,195
No program is registered to open this file chuckm	by isabelle	1	1,195
Help with Solver witrias	by Megan[_2_]	1	1,195
How can Excel vba detect if Caps Lock or Num Lock is on? abc[_6_]	by abc[_6_]	2	1,194
Code to make a Spinner button work with Filters on a Pivot Table TheTraveler	by Herbert Seidenberg	2	1,194
Column full of email addresses: how to truncate to just part of eachemail address (before the "@") John[_147_]	by Vacuum Sealed	2	1,193
Autofilter problem Ludo	by Ron Rosenfeld[_2_]	9	1,193
Code for multiple select of cells L. Howard	by GS[_2_]	16	1,193
Can we make XY Scatter Chart using Pivot Tables Andy Pope	by Andy Pope	0	1,193
Remove Alpha Characters Minitman	by Ron Rosenfeld	39	1,193
Listbox Auto Column Width Trevor Williams	by JLGWhiz[_2_]	1	1,192
Auto Detect Data, Auto Print Data, Auto Erase Data Loop Gamma's and Ruiter's	by Ron Rosenfeld[_2_]	16	1,192
How to assign a reference to [Validation .add] xlValidateList(?) tbd	by tbd	5	1,191
Dynamic Range in Macro with R1C1 Jonnyboy117	by Jonnyboy117[_4_]	3	1,191
Essbase Add-in VBA programming question pickytweety	by Jim Thomlinson	1	1,191
Tiered Pricing Calculations Siper1	by Jerry Beaucaire	26	1,190
Use VBA code to open a text file with the import wizard George Wilson[_2_]	by George Wilson[_2_]	2	1,190
Run-time Error '1004' Unable to get the findnext property... Tom Ogilvy	by Tom Ogilvy	0	1,189
VBA - Hyperlink Function Combined with Find Nalij	by Nalij	6	1,189
Set Properties of TextBox in VBA Don Rouse	by Don Rouse	4	1,189
Create new sheet based on cell value Chulius Caesar	by Chulius Caesar	2	1,188
jumping to a cell which matches user specified text bikestlr	by Dave Peterson[_3_]	3	1,188
Loop for myRng for next set of 9 rows L. Howard	by Claus Busch	10	1,188
Strange thing with this formula written by VBA [email protected]	by Orlando Magalhães Filho	1	1,188
How do I solve this? Metallo[_3_]	by Metallo[_4_]	14	1,187
401k withdraw calculation eighthman11	by JLGWhiz	2	1,187
function - find first number in row 0, return cell column number cate	by Charabeuh[_6_]	3	1,186
Can I calculate eigenvectors and eigenvalues? Murphy Waggoner	by Robert Crandal	1	1,186
is there a basic profit sharing formula available for a sml office drjurman	by Franz Verga	1	1,185
Extract segments of an array Tatsujin	by dpb	10	1,184
VBA code for if no visible cells after filter goto next stage thomsonpa	by thomsonpa	2	1,184
object.CopyFile() has an error? Robert Crandal[_3_]	by Robert Crandal[_3_]	8	1,184
Excel Templates for Compound Interest Loans W	by suzzy[_5_]	2	1,184
Disable save, save as, but allow save via command button TimN	by TimN	10	1,184
compile error with Mid() function jc	by jc	7	1,183
fname = Dir() returns and 'invalid procedure call or argument' Brenner	by Brenner	4	1,183
Error 1004 SaveAs Object workbook failed cardfan3206	by cardfan3206	16	1,182
api - tracking LostFocus or Exit event of a combobox sebastienm	by Jim Cone	4	1,181
System.Runtime.InteropServices.COMException (0x800401A8) Dave	by Dave	0	1,180
remove duplicates, keeping latest dated record Steve	by Steve	2	1,180
Count Empty Cells in Range After Cells with Data David	by Die_Another_Day	16	1,180
select and paste data based on creteria on previous cells Jerome[_6_]	by Jerome[_6_]	2	1,179
How to download: "Microsoft Forms 2.0 Library"? Robert Stober	by Tom Ogilvy	1	1,179
VBA: Select Excel's Worksheet using wildcard maxifire	by Steve Hieb	5	1,179
How to insert email signature from EXCEL VBA Eric_G	by JP[_4_]	5	1,179
Problem with ExportAsFixedFormat in Excel 2007 Robert Simpson	by [email protected]	9	1,179
No Subject No Name	by No Name	0	1,178
Check if UserForm is loaded? Charlotte E[_2_]	by GS[_5_]	11	1,178
Window Class of UserForm controls Bob Phillips	by Chip Pearson	4	1,177
VBA macro generating MD5 [email protected]	by Tom Ogilvy	1	1,177
VBA Check Spelling doesn't highlight misspelled word TWhizTom	by r c	5	1,176
pivot table error:Cannot open PivotTable Source file!!!!!!!! No Name	by Frank Kabel	1	1,176
Subtotal method of Range class failed childofthe1980s	by Joel	1	1,176
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" Luc[_3_]	by Jim Thomlinson[_4_]	2	1,176
1004 - Move Method of Worksheet Class Failed Buddhaful	by Joel	3	1,175
Issue with ExportAsFixedFormat PDF (and solution) Taylor	by Taylor	2	1,175
Lat & Long to V&H Bill[_26_]	by drbobsled	3	1,175
Excel Add-in path in UNC format Steve Culhane [MS]	by Steve Culhane [MS]	0	1,174
Grab Time with milliseconds included in VBA Erick	by Peter T	4	1,173
Dynamic Offset from an Application.Goto cell = Date or Time L. Howard	by L. Howard	10	1,173
Script Runner Pro Indra Dwi Santoso	by emaillist	1	1,173
formula or macro in excel, to open another excel sheet? [email protected]	by [email protected]	7	1,172
Pivot Tables: Alternative to PivotSelect? Paul Martin[_2_]	by Paul Martin[_2_]	1	1,171
Problems generating an html link based on worksheet values Frederik Romanov	by Frederik Romanov	0	1,171
RTD value changes not triggering worksheet change event DTM[_4_]	by John.Greenan	2	1,169
How to use structured reference (ListColumns) in VBA Carl S.	by Herbert Seidenberg	2	1,169
waiting for another application to complete an OLE action. Marc W	by Marc W	1	1,169
Excel VSTO: Selecting range according to properties JDias	by JDias	1	1,169
VBA and Crystal Ball B Munny	by B Munny	0	1,168
Macro/VBA code to compare lists & highlight similiar items ACCAguy	by John G[_2_]	8	1,167
Trace errant formula to stop annoying message Mark Stephens	by David Lean	13	1,166
Row Height -- Slows VBA [email protected]	by [email protected]	7	1,166
Type Mismatch Error on IF conditional KeriM	by isabelle	3	1,166