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	347
How to get the available languages (MUI) of Excel using VBA? Cat[_3_]	by Cat[_3_]	0	206
Using VBA to close a running application macroapa	by eliano[_2_]	1	220
ADO question Robert Crandal[_2_]	by Robert Crandal[_2_]	15	732
Working with moving dynamic ranges CompleteNewb[_2_]	by Don Guillett Excel MVP	1	192
Excel 2003 autofiltering options from a userform BJthebear	by BJthebear	0	179
cell comments, hiding columns, "Cannot shift objects off sheet" zxcv[_2_]	by Jim Cone[_2_]	1	264
Limit range of values for integer Alan[_8_]	by dksaluki	2	196
How to deploy my new addin Clif McIrvin[_4_]	by Clif McIrvin[_4_]	0	154
Code deletes first row/headers. J.W. Aldridge	by Don Guillett Excel MVP	1	223
Create new worksheet and use a number as its name.. Billy[_6_]	by Don Guillett Excel MVP	1	188
Dynamic Names Don[_3_]	by Don Guillett Excel MVP	1	188
Total by Invoice Number VJ[_5_]	by Don Guillett Excel MVP	1	226
Personal Macro Book Slim Slender[_3_]	by Slim Slender[_3_]	0	187
scrolling 2 frames simultaneously noname	by noname	2	199
parse csv file contents into powerpoint textbox Autoshapes noname	by noname	0	271
Dynamic Names Don[_3_]	by Don[_3_]	0	143
Payment Coupons wx4usa	by wx4usa	0	230
Use VBA to Populate Listbox from Open Spreadsheet Henninger5	by dksaluki	4	1,215
Personal Macro Book Slim Slender[_3_]	by Slim Slender[_3_]	0	250
2007 Table dR	by AP[_6_]	1	251
Totals rows shouldn't become invisible when filtering John[_146_]	by Paul Robinson	3	230
Find a date in list less or equal than target date u473	by Ron Rosenfeld[_2_]	6	308
On-screen buttons turn to white jayray	by jayray	0	193
loop through class module [email protected]	by [email protected]	2	302
Excel model - Very fast first time - Very slow second time Helge's	by Andrew Taylor	1	362
Automatically copy files into folders andreashermle	by AB[_2_]	6	309
How to change a device name into a resource name and v.v. chfa	by chfa	2	232
How to get the current cell position in VBA (eq. Row(), col() in F Johan2000	by Ross Marsden	3	879
Register HelpID via Categories dll Andrew[_16_]	by Miguel Enrique Tello Leyva	7	279
Find Running Total Value or % at a given Target Date or vice versa u473	by Don Guillett Excel MVP	3	280
Duplicate Entries Heera	by Heera	2	221
Range object causing Sort to fail Steven B	by Steven B	2	259
Running a Macro periodically between Time A and Time B Kfletch	by Kfletch	7	398
Generate Subtotal Summary from Sheet1 into Sheet2 u473	by u473	16	539
Remove a criteria from countif based on user selection JT[_8_]	by AB[_2_]	5	393
Title bar not up-dating after running the macro below Johnnyboy5[_2_]	by Dave Peterson[_2_]	5	542
using two cell references to make up the save as file name Johnnyboy5[_2_]	by Johnnyboy5[_2_]	3	245
Stopping a macro to edit the template then re-saving the macro for use Johnnyboy5[_2_]	by Johnnyboy5[_2_]	4	456
Stopping a macro to edit the template then re-saving the macro for use Johnnyboy5[_2_]	by Johnnyboy5[_2_]	0	277
password protection danial mansoor	by Robert Crandal[_2_]	1	175
Saving templete / workbook to a specific drive / file...trying again Johnnyboy5[_2_]	by Johnnyboy5[_2_]	5	379
Conditional formating question Petert[_2_]	by norie	3	247
Change file name when saved to C drive Michael Lanier	by Michael Lanier	2	193
Picture on comment MysticProg	by MysticProg	0	164
save as cell A1 to to a specific drive Johnnyboy5[_2_]	by Johnnyboy5[_2_]	3	233
Help with Excel VBA code [email protected]	by [email protected]	5	257
Using an ADODB.Recordset in Excel 2007 Robert Crandal[_2_]	by Robert Crandal[_2_]	11	594
UTF-8 File Opened in Excel from Firefox Browser Greg Lovern	by Greg Lovern	1	195
Can I do automation on Access if the database is open? Mat N	by Mat N	0	158
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? u473	by u473	2	291
Referring to control value on form using variable name for control CompleteNewb[_2_]	by Dave Peterson[_2_]	5	336
Copying used range from other sheets ignoring row 1 Andy	by AB[_2_]	12	477
Mail Multiple Sheets via PDF Q Seanie	by AB[_2_]	5	241
Saving templete / workbook to a specific drive / file Johnnyboy5[_2_]	by AB[_2_]	1	206
count dates LUIS ANGEL	by AB[_2_]	1	229
Help with VBA code [email protected]	by Dave Peterson[_2_]	1	187
PERSONAL.XLSB will not load pcor	by pcor	0	212
#VALUE Kieran H	by Kieran H	2	242
Sorting problem : "The sort reference is not valid..........." u473	by Dave Peterson[_2_]	3	572
Charts.add or ActiveSheet.ChartObjects.Add doesn't work Oliver[_4_]	by Oliver[_4_]	2	565
Auto select worksheets - and goto a specific cell afterwards Johnnyboy5[_2_]	by Johnnyboy5[_2_]	2	301
SOS! Help! Loading another workbook in the current workbook - cellsnot updating! LunaMoon	by Don Guillett Excel MVP	6	301
counting a specific "text" occurance in a selection of sheets withina workbook Johnnyboy5[_2_]	by Ron Rosenfeld[_2_]	16	692
Addin UDF Registration/Declaration Faraz Ahmed Qureshi	by Peter T[_5_]	20	724
Convert dates gcotterl[_2_]	by Ron Rosenfeld[_2_]	8	415
Group rows based on indention of string in a column Chris123	by Chris123	0	257
Comparing dates gcotterl[_2_]	by MerseyBeat	1	197
Deployment of Excel addin (.xla file) Nayan	by xlWarlock	18	979
Macros I want dont appear in the customise box to drag to a toolbar Johnnyboy5[_2_]	by Gord Dibben[_2_]	1	259
Add-in question: can I store default values for a form in the Add-in? Ed from AZ	by Jon Peltier[_12_]	4	238
ADO connection to a protected workbook? Robert Crandal[_2_]	by GS[_5_]	3	526
How to "freeze" all cells in Excel sheets? LunaMoon	by Don Guillett Excel MVP	2	264
group of worksheets in a workbook Johnnyboy5[_2_]	by Johnnyboy5[_2_]	4	264
countif - in an entire workbook Johnnyboy5[_2_]	by Don Guillett Excel MVP	3	312