Excel Programming - Page 61

Rating Thread / Thread Starter	Last Post	Replies	Views
How to structure specific macro task, oop or procedural approach?(Excel 2003) junglebear	by GS[_5_]	8	364
How to get the available languages (MUI) of Excel using VBA? Cat[_3_]	by Cat[_3_]	0	212
Using VBA to close a running application macroapa	by eliano[_2_]	1	232
ADO question Robert Crandal[_2_]	by Robert Crandal[_2_]	15	743
Working with moving dynamic ranges CompleteNewb[_2_]	by Don Guillett Excel MVP	1	207
Excel 2003 autofiltering options from a userform BJthebear	by BJthebear	0	193
cell comments, hiding columns, "Cannot shift objects off sheet" zxcv[_2_]	by Jim Cone[_2_]	1	274
Limit range of values for integer Alan[_8_]	by dksaluki	2	203
How to deploy my new addin Clif McIrvin[_4_]	by Clif McIrvin[_4_]	0	167
Code deletes first row/headers. J.W. Aldridge	by Don Guillett Excel MVP	1	238
Create new worksheet and use a number as its name.. Billy[_6_]	by Don Guillett Excel MVP	1	191
Dynamic Names Don[_3_]	by Don Guillett Excel MVP	1	194
Total by Invoice Number VJ[_5_]	by Don Guillett Excel MVP	1	234
Personal Macro Book Slim Slender[_3_]	by Slim Slender[_3_]	0	200
scrolling 2 frames simultaneously noname	by noname	2	209
parse csv file contents into powerpoint textbox Autoshapes noname	by noname	0	280
Dynamic Names Don[_3_]	by Don[_3_]	0	151
Payment Coupons wx4usa	by wx4usa	0	239
Use VBA to Populate Listbox from Open Spreadsheet Henninger5	by dksaluki	4	1,226
Personal Macro Book Slim Slender[_3_]	by Slim Slender[_3_]	0	262
2007 Table dR	by AP[_6_]	1	261
Totals rows shouldn't become invisible when filtering John[_146_]	by Paul Robinson	3	235
Find a date in list less or equal than target date u473	by Ron Rosenfeld[_2_]	6	319
On-screen buttons turn to white jayray	by jayray	0	201
loop through class module [email protected]	by [email protected]	2	312
Excel model - Very fast first time - Very slow second time Helge's	by Andrew Taylor	1	370
Automatically copy files into folders andreashermle	by AB[_2_]	6	316
How to change a device name into a resource name and v.v. chfa	by chfa	2	239
How to get the current cell position in VBA (eq. Row(), col() in F Johan2000	by Ross Marsden	3	886
Register HelpID via Categories dll Andrew[_16_]	by Miguel Enrique Tello Leyva	7	292
Find Running Total Value or % at a given Target Date or vice versa u473	by Don Guillett Excel MVP	3	290
Duplicate Entries Heera	by Heera	2	227
Range object causing Sort to fail Steven B	by Steven B	2	273
Running a Macro periodically between Time A and Time B Kfletch	by Kfletch	7	406
Generate Subtotal Summary from Sheet1 into Sheet2 u473	by u473	16	553
Remove a criteria from countif based on user selection JT[_8_]	by AB[_2_]	5	401
Title bar not up-dating after running the macro below Johnnyboy5[_2_]	by Dave Peterson[_2_]	5	554
using two cell references to make up the save as file name Johnnyboy5[_2_]	by Johnnyboy5[_2_]	3	254
Stopping a macro to edit the template then re-saving the macro for use Johnnyboy5[_2_]	by Johnnyboy5[_2_]	4	465
Stopping a macro to edit the template then re-saving the macro for use Johnnyboy5[_2_]	by Johnnyboy5[_2_]	0	286
password protection danial mansoor	by Robert Crandal[_2_]	1	182
Saving templete / workbook to a specific drive / file...trying again Johnnyboy5[_2_]	by Johnnyboy5[_2_]	5	389
Conditional formating question Petert[_2_]	by norie	3	257
Change file name when saved to C drive Michael Lanier	by Michael Lanier	2	204
Picture on comment MysticProg	by MysticProg	0	171
save as cell A1 to to a specific drive Johnnyboy5[_2_]	by Johnnyboy5[_2_]	3	241
Help with Excel VBA code [email protected]	by [email protected]	5	265
Using an ADODB.Recordset in Excel 2007 Robert Crandal[_2_]	by Robert Crandal[_2_]	11	602
UTF-8 File Opened in Excel from Firefox Browser Greg Lovern	by Greg Lovern	1	204
Can I do automation on Access if the database is open? Mat N	by Mat N	0	169
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? u473	by u473	2	301
Referring to control value on form using variable name for control CompleteNewb[_2_]	by Dave Peterson[_2_]	5	351
Copying used range from other sheets ignoring row 1 Andy	by AB[_2_]	12	487
Mail Multiple Sheets via PDF Q Seanie	by AB[_2_]	5	247
Saving templete / workbook to a specific drive / file Johnnyboy5[_2_]	by AB[_2_]	1	216
count dates LUIS ANGEL	by AB[_2_]	1	237
Help with VBA code [email protected]	by Dave Peterson[_2_]	1	200
PERSONAL.XLSB will not load pcor	by pcor	0	225
#VALUE Kieran H	by Kieran H	2	246
Sorting problem : "The sort reference is not valid..........." u473	by Dave Peterson[_2_]	3	588
Charts.add or ActiveSheet.ChartObjects.Add doesn't work Oliver[_4_]	by Oliver[_4_]	2	574
Auto select worksheets - and goto a specific cell afterwards Johnnyboy5[_2_]	by Johnnyboy5[_2_]	2	307
SOS! Help! Loading another workbook in the current workbook - cellsnot updating! LunaMoon	by Don Guillett Excel MVP	6	311
counting a specific "text" occurance in a selection of sheets withina workbook Johnnyboy5[_2_]	by Ron Rosenfeld[_2_]	16	703
Addin UDF Registration/Declaration Faraz Ahmed Qureshi	by Peter T[_5_]	20	733
Convert dates gcotterl[_2_]	by Ron Rosenfeld[_2_]	8	423
Group rows based on indention of string in a column Chris123	by Chris123	0	265
Comparing dates gcotterl[_2_]	by MerseyBeat	1	204
Deployment of Excel addin (.xla file) Nayan	by xlWarlock	18	997
Macros I want dont appear in the customise box to drag to a toolbar Johnnyboy5[_2_]	by Gord Dibben[_2_]	1	264
Add-in question: can I store default values for a form in the Add-in? Ed from AZ	by Jon Peltier[_12_]	4	247
ADO connection to a protected workbook? Robert Crandal[_2_]	by GS[_5_]	3	541
How to "freeze" all cells in Excel sheets? LunaMoon	by Don Guillett Excel MVP	2	277
group of worksheets in a workbook Johnnyboy5[_2_]	by Johnnyboy5[_2_]	4	277
countif - in an entire workbook Johnnyboy5[_2_]	by Don Guillett Excel MVP	3	323