Excel Programming - Page 386

Rating Thread / Thread Starter	Last Post	Replies	Views
How to create Style.Interior.Gradient property Raja	by JLGWhiz	2	505
separate multiline address into separate columns -Dman100-	by -Dman100-	3	307
Macro to tab down 2 cells Steved	by Steved	2	168
UDF Last Save Date returning 3 different results notso	by Sheeloo[_3_]	1	221
merging column values and transferring them to another worksheet louie	by Sheeloo[_3_]	1	157
Retreive part of the value from each cell - Macro and/or forumula [email protected]	by [email protected]	3	320
Macro for save as deeds	by Dave Peterson	2	160
Loop through all sheets, calculate Average in K1 of each sheet ryguy7272	by RyanH	9	276
Filter list in same worksheet issue J.W. Aldridge	by Per Jessen[_2_]	3	170
Find last blank row and use in a formula Alex	by Alex	4	236
BeforeRightClick event vs. Selection Change DennisB[_2_]	by DennisB[_2_]	2	272
Error when opening Embedded Excel File in Word [email protected]	by Joel	1	255
PivotTable/Chart Filter on Click JC	by JC	0	133
Best way to call stored procedure, have results return in cell ran SQLScott	by SQLScott	3	226
Detect file format (version) of Excel file Alan[_8_]	by Daniel.C[_2_]	1	196
Adding User Dialog to Macro JAD	by Michael	2	186
Count number of cells with data validation errors Gareth[_2_]	by Jim Cone[_2_]	3	1,445
MS Query and calculation Cesar	by dmoney	1	186
Find an Alphanumeric in across columns ogopogo5	by ogopogo5	0	183
calculate percentages of 8 hour day digitalmuse	by digitalmuse	2	699
Hide rows with value of 0 chrismv48	by Bernard Liengme	6	265
moving treeview node Ernst	by Ernst	0	213
Closing Outlook VBE from Excel Stephen Lloyd[_2_]	by Stephen Lloyd[_2_]	1	214
Excel sheet with form - Path/File access error Jon	by Per Jessen[_3_]	1	232
Learning VB Paige	by Paige	3	352
Copying specific data from Sheet 1 to Sheet 2 Jock	by Per Jessen[_3_]	1	344
Marco similar to a SAS program Christian Falde	by Gary''s Student	2	213
Writing VBA Code to compare lines of the same invoice. yoshimarine	by Per Jessen[_3_]	1	254
Macro 2003 vs 2007 Lucson	by Danny Khen [MSFT]	6	227
Looking up multiple values with in the same number Charlie	by Charlie	7	242
cut paste row to end of WB based on criteria aileen	by aileen	2	178
How Do I Run An Executable from Excel? [email protected]	by JLGWhiz	1	165
Copy Paste a file into a folder with the current dat [email protected]	by Dave Peterson	1	233
copyFromRecordSet code in excel-vba oscar.c.marin[_2_]	by Mauro Gamberini[_3_]	1	404
Database query and calculation Cesar	by Cesar	2	203
Test if workbook is not yet named wal	by Harald Staff[_2_]	2	160
Shortcut menus in 2007 XP	by XP	2	208
Copy Paste a file into a folder with the current date [email protected]	by Dave Peterson	1	178
Save workbook without code Juan García	by Ron de Bruin	1	162
why does a Visual Basic Window pop up after a screensaver [email protected]	by Orion Cochrane	1	216
Convert Local Names to Global Names Leo Mansi	by Dave Peterson	3	255
Wildcard for space text space pattern LuisE	by Dave Peterson	5	2,590
Selecting Max 20 Numbers Irfan Khan[_2_]	by PJFry	3	214
Excel ribbon problem with Quick access toolbar JJ	by Ron de Bruin	7	680
Better way to apply a formula PJFry	by PJFry	2	442
Lookup in userform without erasing formula everytime Geewiz	by Geewiz	0	157
If end sub Miree	by Mike H	4	207
Error deleting worksheet (Excel 2003) cr113	by cr113	2	191
UserForm Textbox.setfocus help JMay	by JMay	4	229
variable print areas same worksheet joemeshuggah	by joemeshuggah	0	181
How to use Implicit Intersection in a VBA Function James Buist	by Charles Williams	13	619
Open FileName For Input As #FileNum2 - - - File Already Open! [email protected]	by Mike H	1	455
beforerightclick and selection change issue DennisB[_2_]	by DennisB[_2_]	0	187
Consolidated/filtered list issue J.W. Aldridge	by J.W. Aldridge	0	127
Toolbox pops up Mats Samson	by Mats Samson	3	434
QueryTable import keeps appending instead of overwriting. David	by Sheeloo[_3_]	3	276
How do I save a single worksheet to a different file using VBA 03 Alpineskier	by Joel	2	215
Only show currently active file icon XP	by Jim Rech	1	182
embeded excel control doesn't work properly if excel workbook is open through GetObject("xx.xls") Zhiming H	by ZH	2	233
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	200
Adding a Chart with a macro in 2007 PCF_man	by Michael Hudston	3	224
Filtering Phil H.	by Phil H.	3	221
Indirect and matching formula isn't working Bud	by Bud	3	355
Save in VBA? TJ	by Chip Pearson	2	199
Problem with size limit of function's argument declared in VBA Nut MAO	by Joel	1	230
Calculation on data from SQL database sing MS Quwry Cesar	by Joel	1	194
How to remove warnings about rewriting cells? Alexander Aliev	by Joel	1	191
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	360
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	192
scope of public variables [email protected]	by ken	2	148
sample vs. population proportion using a z-score in excel Christopher[_3_]	by N10	1	342
AutoFilter selected row not 'retained' across user unselect/select YoDave	by Dave Peterson	3	188