Excel Programming - Page 386

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