Excel Programming - Page 386

Rating Thread / Thread Starter	Last Post	Replies	Views
How to create Style.Interior.Gradient property Raja	by JLGWhiz	2	506
separate multiline address into separate columns -Dman100-	by -Dman100-	3	316
Macro to tab down 2 cells Steved	by Steved	2	169
UDF Last Save Date returning 3 different results notso	by Sheeloo[_3_]	1	226
merging column values and transferring them to another worksheet louie	by Sheeloo[_3_]	1	159
Retreive part of the value from each cell - Macro and/or forumula [email protected]	by [email protected]	3	323
Macro for save as deeds	by Dave Peterson	2	168
Loop through all sheets, calculate Average in K1 of each sheet ryguy7272	by RyanH	9	284
Filter list in same worksheet issue J.W. Aldridge	by Per Jessen[_2_]	3	173
Find last blank row and use in a formula Alex	by Alex	4	240
BeforeRightClick event vs. Selection Change DennisB[_2_]	by DennisB[_2_]	2	276
Error when opening Embedded Excel File in Word [email protected]	by Joel	1	265
PivotTable/Chart Filter on Click JC	by JC	0	136
Best way to call stored procedure, have results return in cell ran SQLScott	by SQLScott	3	233
Detect file format (version) of Excel file Alan[_8_]	by Daniel.C[_2_]	1	202
Adding User Dialog to Macro JAD	by Michael	2	198
Count number of cells with data validation errors Gareth[_2_]	by Jim Cone[_2_]	3	1,457
MS Query and calculation Cesar	by dmoney	1	196
Find an Alphanumeric in across columns ogopogo5	by ogopogo5	0	189
calculate percentages of 8 hour day digitalmuse	by digitalmuse	2	699
Hide rows with value of 0 chrismv48	by Bernard Liengme	6	273
moving treeview node Ernst	by Ernst	0	219
Closing Outlook VBE from Excel Stephen Lloyd[_2_]	by Stephen Lloyd[_2_]	1	215
Excel sheet with form - Path/File access error Jon	by Per Jessen[_3_]	1	243
Learning VB Paige	by Paige	3	355
Copying specific data from Sheet 1 to Sheet 2 Jock	by Per Jessen[_3_]	1	347
Marco similar to a SAS program Christian Falde	by Gary''s Student	2	214
Writing VBA Code to compare lines of the same invoice. yoshimarine	by Per Jessen[_3_]	1	267
Macro 2003 vs 2007 Lucson	by Danny Khen [MSFT]	6	228
Looking up multiple values with in the same number Charlie	by Charlie	7	252
cut paste row to end of WB based on criteria aileen	by aileen	2	179
How Do I Run An Executable from Excel? [email protected]	by JLGWhiz	1	171
Copy Paste a file into a folder with the current dat [email protected]	by Dave Peterson	1	243
copyFromRecordSet code in excel-vba oscar.c.marin[_2_]	by Mauro Gamberini[_3_]	1	417
Database query and calculation Cesar	by Cesar	2	210
Test if workbook is not yet named wal	by Harald Staff[_2_]	2	164
Shortcut menus in 2007 XP	by XP	2	209
Copy Paste a file into a folder with the current date [email protected]	by Dave Peterson	1	186
Save workbook without code Juan García	by Ron de Bruin	1	170
why does a Visual Basic Window pop up after a screensaver [email protected]	by Orion Cochrane	1	221
Convert Local Names to Global Names Leo Mansi	by Dave Peterson	3	261
Wildcard for space text space pattern LuisE	by Dave Peterson	5	2,596
Selecting Max 20 Numbers Irfan Khan[_2_]	by PJFry	3	216
Excel ribbon problem with Quick access toolbar JJ	by Ron de Bruin	7	691
Better way to apply a formula PJFry	by PJFry	2	443
Lookup in userform without erasing formula everytime Geewiz	by Geewiz	0	158
If end sub Miree	by Mike H	4	212
Error deleting worksheet (Excel 2003) cr113	by cr113	2	197
UserForm Textbox.setfocus help JMay	by JMay	4	233
variable print areas same worksheet joemeshuggah	by joemeshuggah	0	186
How to use Implicit Intersection in a VBA Function James Buist	by Charles Williams	13	632
Open FileName For Input As #FileNum2 - - - File Already Open! [email protected]	by Mike H	1	463
beforerightclick and selection change issue DennisB[_2_]	by DennisB[_2_]	0	195
Consolidated/filtered list issue J.W. Aldridge	by J.W. Aldridge	0	128
Toolbox pops up Mats Samson	by Mats Samson	3	435
QueryTable import keeps appending instead of overwriting. David	by Sheeloo[_3_]	3	290
How do I save a single worksheet to a different file using VBA 03 Alpineskier	by Joel	2	230
Only show currently active file icon XP	by Jim Rech	1	183
embeded excel control doesn't work properly if excel workbook is open through GetObject("xx.xls") Zhiming H	by ZH	2	243
Conditional hidden row rtwiss via OfficeKB.com	by Bernard Liengme	1	142
OnKey - usable to assign new shortcuts to existing Excel keyboardshortcuts? wal	by wal	2	205
Adding a Chart with a macro in 2007 PCF_man	by Michael Hudston	3	236
Filtering Phil H.	by Phil H.	3	230
Indirect and matching formula isn't working Bud	by Bud	3	355
Save in VBA? TJ	by Chip Pearson	2	212
Problem with size limit of function's argument declared in VBA Nut MAO	by Joel	1	243
Calculation on data from SQL database sing MS Quwry Cesar	by Joel	1	207
How to remove warnings about rewriting cells? Alexander Aliev	by Joel	1	192
How to remove warnings about rewriting cells? Alexander Aliev	by Mike H	1	158
Matching formula - Can we have a variable field for the row number Bud	by Dave Peterson	5	375
link to a cell in another page in vbe.. pls123	by pls123	6	233
Export specific cell values to an external workbook Razorboy	by Simon Murphy[_2_]	1	200
scope of public variables [email protected]	by ken	2	156
sample vs. population proportion using a z-score in excel Christopher[_3_]	by N10	1	343
AutoFilter selected row not 'retained' across user unselect/select YoDave	by Dave Peterson	3	198