Excel Programming - Page 1347

Rating Thread / Thread Starter	Last Post	Replies	Views
trim left of a found word in a text variable MervB	by Ken Wright	6	231
Averaging a Value Between Two Serial Dates ChrisM[_3_]	by Bob Phillips[_6_]	4	201
COUNTIF / AND functions brianwakin	by Chip Pearson	4	242
Anyone ever try shared workbooks? Sandy	by Tom Ogilvy	5	278
VLookup Problem DA@PD[_2_]	by Ron Rosenfeld	4	193
A problem with Set (Range) Peter	by Jim Thomlinson[_4_]	1	245
Using multiple XLTs [email protected]	by SetonSoftware	2	214
Center Align John 3:16	by John 3:16	5	213
Recalc Time CLR	by Tom Ogilvy	5	208
Search & extract from multiple workbooks Ann	by Tom Ogilvy	6	215
Run .vbs from a Excel macro? SpeeD	by Steve Yandl	5	303
Pivot Problems Philip Wagenaar	by Debra Dalgleish	1	178
Excel VBA - conditional formatting [email protected]	by Tom Ogilvy	1	205
Internetconnection Jos Vens[_2_]	by Jos Vens[_2_]	2	168
Delete every other line Andy	by Andy	2	232
Simultaneous user question Sandy	by Sandy	5	168
How do you change the sign (e.g. +3 to -3 OR -3 to +3) [email protected]	by mbarron[_2_]	3	187
Help with complex VLOOKUP [email protected]	by JakeyC	3	264
CHECK END OF WORKSHEET DATA cndesu	by Tom Ogilvy	3	218
Delete every other line Andy	by Andy	0	260
UserForm ComboBox RowSource Question Minitman[_4_]	by Minitman[_4_]	0	234
Won't accept password to unprotect Frustrated1900	by Frustrated1900	2	352
Read-only protection on Excel Worksheet Stumpiana	by Stumpiana	2	187
macros for printing Andre	by Martin Fishlock[_3_]	2	153
Loop through records [email protected]	by Toppers	6	320
input box format Dan	by Tom Ogilvy	3	276
Parts List comparison report DA@PD[_2_]	by DA@PD[_2_]	3	169
Replace Column Letter only al007	by K Dales[_2_]	3	168
Create a new XLS from a standard XLS matelot	by bpeltzer	2	176
personal macro workbook must stay open for recording Matthew Dodds	by Matthew Dodds	3	568
How do I turn around 'Circulation Reference' msgbox? Zoo	by Dave Peterson	6	335
Need help adjusting selection ranges havocdragon	by Dave Peterson	3	188
commandbar management me[_9_]	by Dave Peterson	1	207
how to effect multiple sheets at one time. L.White	by Dave Peterson	3	294
Averaging Random Selections? Matt R	by Matt R	0	142
Notify when file is open? Rbp9ad[_2_]	by Rbp9ad[_2_]	0	238
range method failed davegb	by davegb	2	220
Import text file problem [email protected]	by [email protected]	0	170
Convert an Excel date to a date of my format in VBA Sunnous	by Tom Ogilvy	1	303
uploading excel data to sql cdneely	by cdneely	0	227
upload data from an excel worksheet to SQL W/ a command Button cdneely	by cdneely	0	225
this is a test Xiaoqiang Huang	by impslayer	2	173
need help righting script to sort rows alphabetically then seperate them to line up [email protected]	by [email protected]	2	235
Using automation to add xy scatter chart Geographer	by Geographer	2	263
ATPVBAEN.XLA!Histogram - macro not found [email protected]	by [email protected]	0	314
Populating cells tmaxwell	by tmaxwell	1	154
syntax for using Excel worksheet function Ben	by Ben	2	246
How can functions be called randomly? [email protected]	by Tom Ogilvy	3	206
Change worksheet formulas from button on chart sheet David	by Tom Ogilvy	1	178
if statement flow23	by tiah	1	164
Software Requirements to run a .NET Excel automation application Phil_769274	by Phil_769274[_2_]	2	182
Charts John[_109_]	by K Dales[_2_]	1	150
How do I return a number for a formatted cell value? gmbhbls	by Ron Rosenfeld	2	240
copying and pasting range problem Henrik	by Tom Ogilvy	1	237
How do i make excel open a new workbook and run a query from sql Dhruv Sampat	by Tom Ogilvy	3	262
vba-password prompt on close kikde	by Tom Ogilvy	3	263
executing an autofilter in VB [email protected]	by Tom Ogilvy	3	270
Referencing an External Sheet without Knowing its Name - XL2K [email protected]	by DoctorG	8	288
Populating 'Comments' with cell value Mark	by Tom Ogilvy	1	161
SUMPRODUCT excel ignore div/0 [email protected]	by Tom Ogilvy	1	508
display an info ballon or message box while a macro is running Micah	by Micah	0	240
#REF! in while loop [email protected]	by Tom Ogilvy	1	206
Copy Pivot Table Data and Paste into New File S Sainsbury	by Tom Ogilvy	1	227
Cell formual result change - Message al007	by Tom Ogilvy	1	203
Loop: Copy and paste range that changes with every iteration Allen Geddes	by Allen Geddes	0	285
help me on condition issues amrezzat[_3_]	by Tom Ogilvy	4	195
Using Functions in VBA code Chris Gorham	by chijanzen	2	365
Set column widths to match specified sheet Sean Bartleet	by Sean	3	179
Save Excel Spreadsheet to PDF vqthomf	by chijanzen	2	185
Loop Column letter A to Z ?? al007	by al007	16	521
UDF only works when focus is on a specific sheet - Help!! Andibevan[_4_]	by Andibevan[_4_]	0	179
UDF only works when focus is on a specific sheet - Help!! Andibevan[_4_]	by Andibevan[_4_]	0	179
formatting background color of a cell with custom colors sprasad	by Bob Phillips[_6_]	4	235
Excel Macros Rey M	by Rey M	3	436
setting source data Nigel	by Nigel	0	201