Excel Programming - Page 2000

Rating Thread / Thread Starter	Last Post	Replies	Views
Sub to automate process Max	by Max	4	252
Sub to carve out uniques based on col header whose position may va Max	by Max	6	246
Sub to change formulas in a col Max	by Max	4	197
Sub to check & force open Parent.xls Max	by Max	6	280
Sub to check and report any formula returned error (eg: #REF!) Max	by Héctor Miguel	5	293
Sub to check data by client n add new symbols to client's list Max	by Max	4	254
Sub to check files in folder and remove Module1 Max	by Max	2	191
Sub to clear cells with zeros or null strings within a selected ra Max	by Max	8	364
Sub to clear pivot filters MichaelR	by MichaelR	0	204
Sub to clear range above n below diagonal Max	by Max	8	325
Sub to compile data from col A in many identical sheets Max	by Max	2	245
Sub to copy a target sheet from slaves from and paste/overwrite into master Max	by Max	19	476
Sub to copy n paste as values based on an "instructions" table Max	by Max	4	214
Sub to copy n paste special discontiguous ranges from 1 sht to ano Max	by Max	4	479
Sub to copy n rename book according to list Max	by Max	1	232
Sub to copy only result lines within formula range, omit null string lines Max	by Max	2	264
sub to create a sub Andrew[_37_]	by Dave Peterson[_3_]	1	177
sub to delete all sheets other than x, y, z Max	by Max	6	191
Sub to delete only all damaged defined ranges in book Max	by Max	2	159
Sub to download all linked files in a webpage to folder? Max	by Max	5	226
Sub to ensure a single, latest input of "x" in col G Max	by Max	4	189
Sub to extract path from hyperlink formula and insert picture into comments Max	by Dave Peterson	12	548
Sub to extract uniques from 200k data in xl03 Max	by Max	28	790
Sub to freeze all sheets & delete all comments Max	by Max	4	165
Sub to freeze cols up to extent of data in col Q Max	by Max	6	210
sub to get post code to post code mileage from web site Atishoo	by Atishoo	3	236
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht Max	by Dave Peterson	11	390
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht Max	by Max	0	190
Sub to lock vbaproject for viewing for all xls in folder using a common password Max	by Max	1	198
Sub to make text bold ksnapp[_7_]	by Bob Phillips[_6_]	1	230
Sub to open n close .xls files in folders Max	by Max	5	259
Sub to replace pictures in a workbook Max	by Dave Peterson	8	190
Sub to stack data n paste unique order ID lines Max	by Max	3	236
Sub to strip away "Sheet" prefix from names Max	by Max	4	227
Sub to transfer values and log the transfer Max	by Max	2	219
Sub to transform table into cols Max	by Max	3	164
Sub to update data Max	by Max	8	201
Sub to write another result dimension into comments over formula c Max	by Max	5	181
Sub to write cell contents into its own comment Max	by Max	2	180
Sub to write formula results into comments Max	by Max	4	175
Sub too large ronreggin	by Greg Wilson	4	261
sub tot column to next blank cell when blank cell exists in both c GaiGauci	by GaiGauci	2	245
sub total kamakshi[_2_]	by R. Choate	1	273
Sub Total Norman Belanger	by Dave Peterson[_3_]	1	217
sub total array violet	by Dave Peterson	1	209
Sub Total collumns Darren via OfficeKB.com	by FIRSTROUNDKO via OfficeKB.com	2	137
Sub Total in worksheet or SUM IF function Shazi	by Shazi	2	162
Sub Total Method URGENT jacqui[_2_]	by David Fixemer	1	194
Sub Total Report Appearance SharonInGa[_2_]	by Debra Dalgleish	1	127
Sub totalling in VBA Peter	by Dave Peterson	1	201
Sub Totals - URGENT jacqui	by jacqui	0	177
Sub Totals with multiple rows and columns Himansu	by Himansu	0	184
Sub unexpectedly jumps to another sub Jeff Wright[_2_]	by Bob Phillips	3	222
Sub vs Function Rob van Gelder[_4_]	by Rob van Gelder[_4_]	10	453
Sub Vs. Function Mike H.	by Chip Pearson	1	168
sub vs. function bhavior regarding 'Workbooks' obj. functions Ali Ahmed	by Harald Staff	1	224
Sub will not find Column "A" Hazel	by Hazel	0	117
sub won't fill down via code SLP	by SLP	3	212
Sub Workbook_Open and BeforeClose not working Dorothy	by Dorothy[_5_]	2	261
Sub Workbook_Open not called when opening spreadsheet dhputnam	by dhputnam	6	288
Sub works sometimes Barry-Jon	by Barry-Jon	0	131
Sub works sometimes and sometimes doesn't Barry O''Connell	by Peter Huang [MSFT]	3	190
Sub Worksheet_Change(ByVal Target As Excel.Range) Questions Wescotte	by Bob Phillips[_6_]	3	236
Sub Worksheet_Change(ByVal Target As Excel.Range) Questions Wescotte	by Wescotte	3	184
Sub() calling Sub()'s in the "worksheet event code€ passing toggle CRayF	by Myrna Larson	2	257
Sub(), Modules, and Private/ Global variables J@Y	by [email protected][_2_]	4	218
Sub, module?? Francis Gaudreau	by Bob Kilmer	2	259
Sub, not function! Zurn[_4_]	by Zurn[_4_]	0	165
Sub, not function! Zurn[_3_]	by Zurn[_3_]	0	166
Sub, not function! Zurn[_5_]	by Chip Pearson	1	176
Sub, not function! Zurn[_2_]	by Harald Staff	1	161
Sub-Menu Listings thall600	by Bob Phillips	2	174
sub-range Stefi	by Stefi	2	476
Sub-total questions jtm3001	by Jim Thomlinson	5	174
Sub-total using Advanced Filter? Ray	by Joel	4	266