Excel Programming - Page 978

Rating Thread / Thread Starter	Last Post	Replies	Views
Querying a SQL Server Database Chaplain Doug	by Bob Phillips[_6_]	6	334
ActiveX alert message Alex	by Alex	0	214
Network Days Count accuracy Ann	by Ann	0	195
Referencing 0 generated from IF(isna(Vlookup) formula DA@PD[_2_]	by DA@PD[_2_]	0	173
Unwanted "quotes" Vance Lee Meurer	by Vance Lee Meurer	0	169
Inspecting cells in a row in a named range Jim[_60_]	by Jim[_60_]	0	164
Is there a Limit to the Amount of Data you can Link to? K W Muter	by Ken Wright	1	188
Pivot Table Question. Ken Wright	by Ken Wright	0	135
Removing Conditional Formatting JudithJubilee	by JudithJubilee	0	171
Removing textbox padding, how to please, Excel 2000/2003 Mike	by Leith Ross[_282_]	2	234
Creating QueryTable from VB6 Jake Marx[_3_]	by Jake Marx[_3_]	0	165
Stuck addin loaded helmekki[_102_]	by helmekki[_102_]	0	225
UDF needed Dorn	by Bob Phillips[_6_]	1	179
How can I find vaues of cells using 2 search criteria? Spinnerron	by Rowan Drummond[_3_]	3	314
Copying from closed files and IF statement Robert	by Robert	8	190
Create a Button that will print sheets Helen	by Helen	2	152
Error of old type library or unrecognized HRESULT JoKi	by JoKi	0	245
How do I remove repeating rows automatically in excel? [email protected]	by Norman Jones	1	264
ADO: Empty field augustus	by augustus	0	182
Changing Cell Values RD Wirr	by RD Wirr	3	172
Combine two linked fields in one cell Helen	by Helen	2	154
Hiding rows based on cell content brutus	by brutus	5	356
How do I sendkeys to Interner Explorer from Excel? els	by els	0	186
da@pd DA@PD[_2_]	by bpeltzer	1	168
Saving A Read Only File? TK[_3_]	by Rowan Drummond[_3_]	1	168
date warning glueboy	by George Sp	2	159
Retrieving the formula contents of a chart title [email protected]	by [email protected]	0	137
Possible to reference column of named range in array formula? Kel Good	by Peter Huang [MSFT]	4	291
setting source data Nigel	by Nigel	0	184
Excel Macros Rey M	by Rey M	3	432
formatting background color of a cell with custom colors sprasad	by Bob Phillips[_6_]	4	214
UDF only works when focus is on a specific sheet - Help!! Andibevan[_4_]	by Andibevan[_4_]	0	167
UDF only works when focus is on a specific sheet - Help!! Andibevan[_4_]	by Andibevan[_4_]	0	164
Loop Column letter A to Z ?? al007	by al007	16	506
Save Excel Spreadsheet to PDF vqthomf	by chijanzen	2	167
Set column widths to match specified sheet Sean Bartleet	by Sean	3	172
Using Functions in VBA code Chris Gorham	by chijanzen	2	333
help me on condition issues amrezzat[_3_]	by Tom Ogilvy	4	191
Loop: Copy and paste range that changes with every iteration Allen Geddes	by Allen Geddes	0	264
Cell formual result change - Message al007	by Tom Ogilvy	1	189
Copy Pivot Table Data and Paste into New File S Sainsbury	by Tom Ogilvy	1	217
#REF! in while loop [email protected]	by Tom Ogilvy	1	189
display an info ballon or message box while a macro is running Micah	by Micah	0	226
SUMPRODUCT excel ignore div/0 [email protected]	by Tom Ogilvy	1	492
Populating 'Comments' with cell value Mark	by Tom Ogilvy	1	147
Referencing an External Sheet without Knowing its Name - XL2K [email protected]	by DoctorG	8	259
executing an autofilter in VB [email protected]	by Tom Ogilvy	3	262
vba-password prompt on close kikde	by Tom Ogilvy	3	247
How do i make excel open a new workbook and run a query from sql Dhruv Sampat	by Tom Ogilvy	3	230
copying and pasting range problem Henrik	by Tom Ogilvy	1	225
How do I return a number for a formatted cell value? gmbhbls	by Ron Rosenfeld	2	227
Charts John[_109_]	by K Dales[_2_]	1	146
Software Requirements to run a .NET Excel automation application Phil_769274	by Phil_769274[_2_]	2	163
if statement flow23	by tiah	1	142
Change worksheet formulas from button on chart sheet David	by Tom Ogilvy	1	167
How can functions be called randomly? [email protected]	by Tom Ogilvy	3	187
syntax for using Excel worksheet function Ben	by Ben	2	228
Populating cells tmaxwell	by tmaxwell	1	146
ATPVBAEN.XLA!Histogram - macro not found [email protected]	by [email protected]	0	301
Using automation to add xy scatter chart Geographer	by Geographer	2	245
need help righting script to sort rows alphabetically then seperate them to line up [email protected]	by [email protected]	2	211
this is a test Xiaoqiang Huang	by impslayer	2	160
upload data from an excel worksheet to SQL W/ a command Button cdneely	by cdneely	0	209
uploading excel data to sql cdneely	by cdneely	0	208
Convert an Excel date to a date of my format in VBA Sunnous	by Tom Ogilvy	1	287
Import text file problem [email protected]	by [email protected]	0	162
range method failed davegb	by davegb	2	195
Notify when file is open? Rbp9ad[_2_]	by Rbp9ad[_2_]	0	229
Averaging Random Selections? Matt R	by Matt R	0	130
how to effect multiple sheets at one time. L.White	by Dave Peterson	3	277
commandbar management me[_9_]	by Dave Peterson	1	188
Need help adjusting selection ranges havocdragon	by Dave Peterson	3	180
How do I turn around 'Circulation Reference' msgbox? Zoo	by Dave Peterson	6	325
personal macro workbook must stay open for recording Matthew Dodds	by Matthew Dodds	3	563
Create a new XLS from a standard XLS matelot	by bpeltzer	2	165