Excel Discussion (Misc queries) - Page 515

Thread / Thread Starter	Last Post	Replies	Views
microsoft excel 97 toolbars won't save settings [email protected]	by Dave Peterson	1	782
Sum of large minute/second figures eacollins	by Ian	2	355
Diabetics eact	by eact	0	362
Help With Formatting EAD	by EAD	0	282
Charts and ... [email protected]	by [email protected]	0	333
Total based on text dependancy + number value in adjacent cell EAE	by Michelle	4	1,015
Creating a Cross Reference table/Matrix eaeu090	by T. Valko	2	5,203
All 0's on Pivot Table Sum, Data NOT text eagarcia08	by eagarcia08	2	3,930
Opening old 2003 spreadsheet in 2007 eager customer	by Don Guillett	1	459
How to Insert Excel file into webpage EagerGit	by EagerGit	0	465
Vook Up Table - how to setup eagle	by Barb Reinhardt	1	513
Macro I think???? Eagle	by Eagle	2	291
Row Height question Eagle	by Eagle	3	332
refresh advanced filter results eagle	by Max	2	1,495
Excel 2000 and Excel 2003 Eagle	by Jim Cone	1	277
Is there a way to insert suprascripts in excel? eagle	by T. Valko	3	386
Payroll Calculator Excel Template Eagle View	by Eagle View	0	874
Payroll calculator template Eagle View Construction	by Eagle View Construction	0	1,739
Can a Timeline be put to scale (15,000 yr datapoint spread)? eagle.al	by Adam	1	682
add sheets to exsisting file eagle1247	by Jim Thomlinson	1	422
File is already open by user X eagle13	by Dave Peterson	1	454
font color Eagle7	by Michael Malinsky	1	655
missing object library eagle7	by Peo Sjoblom	2	720
Sorting Dates in Days of the Week Eagle784	by David McRitchie	3	610
VBA to address first visible cell in Column "D" after filtering EagleOne	by EagleOne	2	6,654
ActiveSheet.CircularReference.Address loses "Set" EagleOne	by EagleOne	2	554
How to "return" the array element number in VBA EagleOne	by EagleOne	4	1,209
Method 'MacroOptions' of object'_Application' failed Runtime Error 1004 EagleOne	by johnywhy	1	3,240
VBA Numbers to Text or Date to Text EagleOne	by EagleOne	0	740
How to activate (in the Project Explorer window) using VBA EagleOne	by EagleOne	0	1,041
Excel 2007 unrecognized file format in Excel 2003 More options EagleOne	by Jim Rech	1	2,006
How to "Replace()" multiple characters in one VBA command line EagleOne	by JE McGimpsey	1	4,316
Help with VBA InStr() function EagleOne	by Dana DeLouis	10	3,638
How to Count the number of "rows" (or Array items) included in a Sumif formula? EagleOne	by EagleOne	3	823
How to AutoFilter certain cells in a column (in Excel not VBA) for an Asterisk "*" ? EagleOne	by EagleOne	2	1,751
Which XL formula calculates Present Value of a single lump-sum Payment in 2027? EagleOne	by [email protected]	2	1,779
How to get a dump of Fill Color & Font VBA Constants? EagleOne	by EagleOne	3	768
HOw Restore Column Width EagleOne	by EagleOne	4	926
"Too Many Cell Formats" Got Fix! But ... need VBA Variable reset EagleOne	by Franz Verga	1	1,295
How to increment within For Next Loop EagleOne	by Dave Peterson	1	303
VBA code to "background-color" a cell obtaining a value from Row EagleOne	by EagleOne	1	552
Minimum qualifiers to Find (VBA) the actual last used Row, Column EagleOne	by Dave Peterson	3	579
Obtain drive letter assignment of CD/DVD drive? EagleOne	by EagleOne	1	599
Hyperlink Option on Right-click short-cut menu gone? EagleOne	by Ron de Bruin	10	2,091
Hyperlink Address and SubAddress not concatenating correctly EagleOne	by EagleOne	0	1,276
Event (BeforeSave) - How to test VBA code? Dave P. can you hear me now? EagleOne	by Dave Peterson	3	1,089
Formula to Replace or eliminate any sheetname(s) in formula string EagleOne	by EagleOne	0	577
On Error Resume Next (when next statement is Do Loop ...) EagleOne	by EagleOne	2	1,390
Syntax to obtain the SubAddress of a Hyperlink in A1 on Sheet1 EagleOne	by EagleOne	0	487
Conditional Formating - formula not working EagleOne	by EagleOne	11	1,106
How to display remaining txt file which overflowed MsgBox display? EagleOne	by Andy Pope	1	847
How to xFer via VBA a VBA variable to Form EagleOne	by Allllen	1	710
How to force a cell value to change if Linked cell moves? EagleOne	by Dave Peterson	2	686
Sorting on partial Cell contents VBA EagleOne	by EagleOne	2	1,706
Clear BorderAround in VBA EagleOne	by Don Guillett	16	2,331
How to Link on [Sheet(1) Window(1)] to [Sheet(2) Window(2)] ? EagleOne	by EagleOne	0	542
Can Offset() be used in Excel cell formulas when filtered (visible-only)? [email protected]	by [email protected]	0	1,301
Macro fine Run fine from Select but not from KB Shortcut? [email protected]	by Dave Peterson	8	1,066
SUMPRODUCT() challenge - How to integrate a string value in lieu of a value in a cell ..... [email protected]	by Ron Rosenfeld	3	707
Run-time error '-2147319779 (8002801d)1: solved! [email protected]	by [email protected]	0	3,627
VBE - Possible to have one of five modules in a VB project to be "default"? [email protected]	by [email protected]	2	406
FIX: Annoying inconsistent errors in Excel via Access automation [email protected]	by [email protected]	0	501
How with VBA, can I activate one of many modules in a VBAProject? [email protected]	by Earl Kiosterud	1	513
MATCH() or VLOOKUP() across mutliple 65K sheets possible? [email protected]	by Jim Thomlinson	4	486
Want A1 to receive contents of R (from MATCH()) and C (COLUMNS(R1) [email protected]	by [email protected]	9	434
Why Copy/Paste fails using Offset & Resize of myRange? [email protected]	by [email protected]	3	748
In VLOOKUP() can one "fetch" a range of columns? [email protected]	by L. Howard Kittle	5	401
Merged Cells in Worksheet, Test for [email protected]	by EagleOne	2	400
VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links [email protected]	by Dave Peterson	5	794
Compile VBA code? (Passwording too weak a protection scheme?) [email protected]	by JLatham	1	758
Need Visual Basic for AppSentinel? [email protected]	by EagleOne	5	364
Worksheet Sort - but all sheets in array do not exist [email protected]	by [email protected]	2	426
Anyone verified if 8192 non-contiguious cell delete fixed in XL 2007? [email protected]	by [email protected]	2	462
Best way to trap error to MsgBox "Too many cell formats" [email protected]	by [email protected]	0	760
Pagesetup.Orientation need VBA routine to "Best Guess" Orientation [email protected]	by Craig Weirich	3	1,497