Excel Programming - Page 936

Rating Thread / Thread Starter	Last Post	Replies	Views
Determine if a File Exists Connie	by Bob Phillips	1	479
Multiple look-up / summing MikeCM	by MikeCM	0	159
Compare 2 lists and show reconciliing items MikeCM	by MikeCM	2	225
When Using Format(Now(), "yyyymmmddhhmm") get wrong number of arguments or invalid property assignment Error Connie	by Connie	2	327
Special Filter Macro - one rngFilter, several Worksheets filtered ricowyder	by ricowyder	9	428
Store range of values in an array Trevor Shuttleworth	by Trevor Shuttleworth	6	251
Wierd - when saving wb & protected...it opens with sheet 'down' Mike R.	by Tim Mayes	5	223
showing a listbox with last entry as the default Katrina	by Katrina	3	278
Assign variable ListBox names chris[_2_]	by chris[_2_]	2	221
Import data into Excel sheet from CSV File Connie	by Connie	3	262
WorkBook _SaveAs method help [email protected][_2_]	by NickHK	3	192
Chart to PPT from linked sheets J@@[_2_]	by J@@[_2_]	3	190
How to insert color in row or cell? Sam	by Sam	2	230
hide sheet tab and protect x taol	by NickHK	1	168
Navigate between 2 workbooks Graham	by Graham	4	238
Template Help Task Pane Appears When Workbook Is Open Connie	by Connie	0	157
Duplicated code window and userform window problem Zhu	by NickHK	3	275
track changes on an excel sheet amar	by amar	0	167
sorting a one dimensional array Albert	by Albert	3	186
forgotten array Albert	by NickHK	9	304
FYI: One macro really helped for capturing data from multiple workbook stored in a specific folder to one excel file only Smits	by Smits	0	259
Can sumproduct do this...... Sonic	by Sonic	2	158
Sort question JOM	by JLGWhiz	1	153
BeforeDoubleClick processing question(s) Forms / Send to .....VBA or Macro?	by JLGWhiz	2	247
Storing data in MS Access from Excel VBA S Chakraborty	by S Chakraborty	0	216
Any experts on the "if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! Chris	by Chris	7	209
Selecting next to highest number in an array? [email protected]	by Tom Ogilvy	2	159
Reset variables DG	by NickHK	2	212
Only for experts - please help Miguel Castanuela	by NickHK	2	276
GETPIVOTDATA TheRook	by Debra Dalgleish	1	150
setting multiple values in array at once? havocdragon	by NickHK	1	199
Excel VBA Vlookup [email protected]	by [email protected]	2	258
remove item from list box Baha	by Baha	0	147
Custom control event problem [email protected]	by Doug Glancy	1	139
A challenge wildauk	by wildauk	2	172
Assign Macro to Checkbox jafsonic	by Dave Peterson	8	760
Displaying Chart on Userform (with Scroll Bars) wanderlust	by Jon Peltier	3	602
Loop Routine in Excel David	by David	3	175
Delete column if a cell is not named Mirja[_2_]	by Peter T	5	195
list sub totals Super Slueth	by Super Slueth	0	146
Select specific Project in VBA Noemi	by Noemi	3	211
CommandButton State Mats Samson	by Mats Samson	2	170
Force use of a date picker control JT	by JT	0	151
Help with auto filter jln via OfficeKB.com	by jln via OfficeKB.com	0	148
Passing range to a Sub Barb Reinhardt	by RB Smissaert	2	168
Print dialog return help needed BrianG[_3_]	by BrianG[_3_]	2	340
Replacing Chr(10) in a string Barb Reinhardt	by Ron Coderre	2	220
please help with syntax in code tracks via OfficeKB.com	by tracks via OfficeKB.com	17	503
How to find the first occurence of any number in a string Caio Milani	by RB Smissaert	2	309
Macro To Print Files By A Listing of Filenames And Paths Chris_In_Raleigh	by Chris_In_Raleigh	0	259
R1C1 and A1 style conflict in formula problem mikeb	by Dave Peterson	9	210
Worksheet Button Properties smxbob	by Norman Jones	3	209
how to define range for autofill without knowing the last row . Teji	by Teji	0	187
AutoFilter button ocean	by ocean	7	217
Merge columns into single list and replace with count of occurrences [email protected]	by Gazeta	1	155
Text in DAtes Joel	by Bob Phillips	1	149
network location bernd	by Dave Peterson	1	178
Variable in cell reference Super Slueth	by Bob Phillips	1	165
Text in dates Joel	by Joel	0	153
macro or function ssrvant	by ssrvant	0	152
Paste totals from 1 sheet to another jln via OfficeKB.com	by jln via OfficeKB.com	0	209
Need to create "on change" logic. Helmut	by Helmut	2	164
Saving a variable value ed	by Bob Phillips	3	181
Delete Worksheet Condition Vicki	by Vicki	1	184
How to use/evaluate another Cell Formula in R1C1 style Caio Milani[_2_]	by Caio Milani	2	568
Find & Move Sheets have_a_cup[_3_]	by have_a_cup[_3_]	0	139
Remove duplicated Items in combo box [email protected]	by Dave Peterson	3	204
Cell to display text from cell on focus?? [email protected]	by [email protected]	2	281
lost VBA editor toolbars... Buffyslay	by Buffyslay	3	526
Adding formating jln via OfficeKB.com	by Bob Phillips	1	167
Macro to insert formula failing...need help Dagonini	by Bob Phillips	3	157
Count Space, comma and fullstop in a string Rahul Gupta	by Bob Phillips	6	579
Calling a function in another module Barb Reinhardt	by Bob Phillips	4	262
Edit query in excel chinna sankar	by chinna sankar	0	221
Closing a workbook [email protected]	by [email protected]	3	154