TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 8
Archive
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
view full version:
back to formated view
2451:
Why does Excel think it's "Picture 7" instead of "Picture 1?"
2452:
tabs in webpage
2453:
COMException on InvokeMember
2454:
Multiple same rows only one column changes
2455:
export into Q BOOKS 07
2456:
Web query returned no data - turn off annoying message pop ups!
2457:
CountA formila for a varying range
2458:
Entering Formula using Array
2459:
Can't use COUNT function to count.csv rows?
2460:
Database Query
2461:
execute code after web query
2462:
formulas showing up in empty cells all by themselves
2463:
Checking if the sum of a percentage is equal to one
2464:
Visible data entries
2465:
Creation of a table of n values
2466:
Copy second row and Last row to new worksheet
2467:
setting up excel program for a swimming meet
2468:
Stopping A Macro
2469:
Runtime error '1004' Cannot change part of a merged cell
2470:
Error 91 - Opening Word from Excel
2471:
I NEED macro for Combinations , Permutations or Arrangements ??
2472:
referencing a checkbox
2473:
Formula error
2474:
Solver
2475:
how do i type something in a cell using vba?
2476:
copy Vlookup down
2477:
Counting occurences of text string in a text file
2478:
Auto Cell Shading
2479:
countif across worksheets
2480:
I have a created a variable with a loop, how do I find average of
2481:
I have a created a variable with a loop, how do I find average of
2482:
Selective paste
2483:
Track tabs
2484:
ActiveSheet.name not returning Sheet1, Sheet2
2485:
Hopefully easy macro question
2486:
Embed Word File
2487:
Hopefully easy macro question
2488:
Attention-flashing when a value is exceeded
2489:
List all e-mail addresses in Contacts in excel
2490:
Variable Command for VBA in Excel
2491:
Control of workbook
2492:
Programmatically inserting a page break
2493:
Searching Column and deleting cells -VBA
2494:
Send E-Mail with a hyperlink in it - Question
2495:
Sending Email notification when a spreadsheet is updated?
2496:
Find Method vs. For...Next Loop
2497:
Retain decimal places in a concatenate function
2498:
Quitting Macro
2499:
Help with code please
2500:
EXCEL SAYS DISK IS FULL WHEN ITS NOT
2501:
Yet more filters...
2502:
Selecting the next blank cell.
2503:
Count number of times entries are made in a cell
2504:
ListDataFormat property been deprercated?
2505:
Changing Marco
2506:
Changing Marco
2507:
Copy Row to Another Sheet Based on Cell Value
2508:
Date formula to return two digit year
2509:
Inserting Drop down on sheet - Array needed
2510:
auto adjusting cell size and row height
2511:
consolidating workbooks into one workbook
2512:
Insert long formula
2513:
Excel Add-on Development.
2514:
Merging Blank Cells
2515:
Cant connect to Access database from excel using vba
2516:
Skipping Blanks
2517:
Programmatically determining if workbook is opened as Read Only
2518:
**Pop-up message prompting for user information**
2519:
Change columns after certain point
2520:
Programming help needed
2521:
Copy sheet in a workbook
2522:
Opening file question
2523:
Sum and Counta function in Listbox for UserForm
2524:
VBA count number of cells
2525:
VBA Programming with Checkbox
2526:
List of function descriptions and field descriptions
2527:
Sorting makro
2528:
e-mail excel files from a folder
2529:
Open Excel locked file using password without office installed
2530:
Data Validation Question
2531:
Anti-Virus Program Deleted VBA codes from Personal.xls
2532:
Perplexing string manipulation problem
2533:
Opposite of a marco
2534:
Sentence Capitalization - Revisited
2535:
Custom number format
2536:
PublishObjects.Add in reverse order
2537:
Editing Marco
2538:
how to do these things in Excel with and without VBA?
2539:
Call a UserForm based on ComboBox selection
2540:
modification of Per Jessen Macro- paste/overwrite
2541:
Excel Pop-up Question
2542:
AutoFilter or something like it
2543:
Hover Text that carry over into Web Format
2544:
Updating a Excel calendar based on range values
2545:
checking if a sheet exists
2546:
VBA Function Not Recognized or Execution Issue
2547:
Lookup Table and output three or more entries
2548:
Debugging
2549:
Copying worksheets into separate workbook and emailing separately.
2550:
How to force close the worksheet without having Excel prompt?
2551:
Error Messages: 'Text String is Too Long...'; 'Can't Record Macro'
2552:
running an excel program
2553:
Code for inserting Comment field with spreadsheet protection
2554:
Breakdown grouping
2555:
Disable the redX in a form
2556:
Delete rows if range is null and not in color...
2557:
Excel Screen refresh while VBA is running
2558:
.Sendmail to Multiple Internal Addresses
2559:
Never used a button before
2560:
Column width reset
2561:
Column values
2562:
Send Mail to multiple recipients in same network....
2563:
Look for Sheet name, and then skip...
2564:
Makes Changes to Closed Excel File on LAN
2565:
adjust .Sendmail for mutiple recipients on internal email network
2566:
Source of Data Files?
2567:
Excel (not spreadsheet) Screen refresh while VBA is running
2568:
Macro to retrieve stock quotes in Excel 2007
2569:
Drop Down List Showing Two Cells Info
2570:
checking numbers in VBA
2571:
Create automated Supplier Scorecard Report from Excel
2572:
Hide Autoshape based on Cell Value
2573:
calculating difference between date/time fields
2574:
Font size and color change for selected cell only
2575:
Rebuilding a corrupted workbook
2576:
Refedit-automation error
2577:
Filling in the blanks methods?
2578:
Session Times
2579:
In my Excel "active application add-ins" not properly enable
2580:
String Functions
2581:
Loop Do Until question
2582:
VBA Function to Increase the Selected Cell Font.
2583:
Copying an unspecified column range
2584:
Copying Entries Help
2585:
Job survey
2586:
The Differences between running a Shell in Excel 2003 and Excel 20
2587:
The Differences in the Shell Command in Excel 2003 and 2007
2588:
manipulating results of autofilter in vba
2589:
how do i call an Outlook Procedures in Excell Macro
2590:
Application.EnvelopeVisible=False problem
2591:
Page number within a worksheet
2592:
strange VBA behavior with named ranges
2593:
Grey screen issue - HELP
2594:
Problem with ActiveWorkbook.EnvelopeVisible
2595:
Reformat & Combine Word Tables, Then Import Into Excel
2596:
Chart Macro?!! Help Please
2597:
Chart Macro?!! Help Please
2598:
Sendmail vs different computers
2599:
application defined or object defined error
2600:
Marco formatting
2601:
Excel List Object Field Types
2602:
Looping through clumns and switch to rows
2603:
Using Ctrl + Copy and Paste across multiple instances of Excel
2604:
Design Mode switching is not working
2605:
Insert Image in an sheet
2606:
Conditional Statements
2607:
Workbook_Open does not run for Addin
2608:
255 char limit on TextBox
2609:
Autosave doesn't work
2610:
help with Application.EnvelopeVisible
2611:
if then statement help
2612:
goto statement in VBA
2613:
Error occur while loading Sheet1811111111111111111" Help Please!
2614:
if then statement help
2615:
Excel List Object Field Types for SharePoint
2616:
Extract data to new sheet
2617:
Make a shortcut to a file - code
2618:
taking characters from last name and first name to create a passwo
2619:
Email to a distribution list in Excel - Simple Version Please
2620:
ReadOnly
2621:
Creating a hyperlink in VBA for an autoshape
2622:
Marco
2623:
Application.calculate not working
2624:
Runtime error 91
2625:
Some changes in a Macro ..
2626:
delete last line of numbers
2627:
Can't delete sheets in Excel
2628:
for each c in range.. how set counter "minus 1"?
2629:
Why does Sheet.Range("A1").Select not work!!!
2630:
Moving entire column
2631:
Deleting Macros in Personal XLSB file
2632:
Public Sub For UserForm TextBoxes & Named Ranges
2633:
Almost there with procedure error
2634:
I hope someone can help me with a formula
2635:
Protection So Workbook Can't Be Opened
2636:
Manual Calculation
2637:
putting info from one file into another using vba
2638:
save file with macro - web folder
2639:
Check Validation via Excel VBA code.
2640:
Getting result from a Pivot Table - Question
2641:
Process of records
2642:
Delete All Rows Above Trigger
2643:
Function is Excel 2007
2644:
comparing rows of two workbooks
2645:
Fill Down VBA help please
2646:
Open Calculator in Office 2008 by vba
2647:
Programmatically retrieving constants
2648:
Enable users to edit charts on a protected worksheet
2649:
Summing up subtotals according to conditions
2650:
vba custom function sum highest consecutive numbers in range excel
2651:
adding code in runtime
2652:
selection.sort process increase file size by 4.5mb
2653:
Saving File
2654:
Trace errant formula to stop annoying message
2655:
clear rows and insert records from recordset on refresh
2656:
User-defined function to give blank cell?
2657:
Need Help
2658:
Initilizing the New DropDown feature
2659:
clear rows and insert records from recordset on refresh
2660:
InsertLines Syntax
2661:
Custom toolbar adding and deleting
2662:
Print format
2663:
Hiding two columns
2664:
Conditional Format and auto filter
2665:
Help needed: Getting all sheet setup data from one workbook to
2666:
Macro to protect and unprotect all sheets of the current workbook
2667:
Macro to test sheet and workbook protect and unprotect status.
2668:
Window Trigger Event.
2669:
What is wrong with this range???
2670:
How do i save a image to the same folder my .xls file is located?
2671:
protecting and unprotecting more than 1 worksheets
2672:
cpu saving..
2673:
Protecting and Unprotecting more than 1 worksheets
2674:
opening an excel file from a website using vba
2675:
Calling a subroutine with a command button
2676:
Insert page number into cell
2677:
Importing text file without end-of-line delimiter?
2678:
"=" in text file formatting messes with my code loop- more elegant (and faster) solution?
2679:
Setting Criteria in VBA
2680:
Opening an XLA and then forgetting about it?
2681:
VBA SharePoint List Field Type assignments
2682:
Combine Custom Function Results
2683:
Solver and 64 bit
2684:
Copy Sync with Shell
2685:
Always accept my changes
2686:
matching
2687:
Moving the Mouse...
2688:
searching in visual basic
2689:
sequencing numbers
2690:
Deleting duplicate rows when creating a CSV automatically
2691:
older version and newer version of excel
2692:
Finding Workbook name - HELP
2693:
Transposing based on cell value
2694:
Line numbering in code
2695:
Strange character pops up in my spreadsheet
2696:
e-mail
2697:
AddIn: IDTExtensibility::BeginShutdown hiding GUI elements too lat
2698:
Run Every 15 mins
2699:
Grabbing string values from the end of a string of an unknown length
2700:
changing views from outlok to excel VB Help
2701:
Update multiple pivot tables
2702:
Accept EULA ?
2703:
Problem with macro in Excel 2007
2704:
How to change the text color using formulae?
2705:
Excel 2003 - Shapes
2706:
Workbook_open Event
2707:
Event triggered in Excel's cell by DDE
2708:
re arranging data in a worksheet
2709:
Sun a macro when a cell is calculated
2710:
What are the events get fired when Excel gets loaded with all shee
2711:
excel combobox
2712:
How to stop UDF in Original ref'ng copied range
2713:
Link: Unable to read file
2714:
Set row number for Date function in while loop?
2715:
Show Last Record in the Listbox when userform Loads.
2716:
How to show Last Record in ListBox when loaded.
2717:
Comparison Macro + In string text highlighting
2718:
Calculating Hours from Textbox Times
2719:
Searcing for an Excel event.
2720:
I don't know how to write a macro that would update the workbook
2721:
Combobox.DropDown not working
2722:
Why Excel 2003 VBA program not working in Excel 2007?
2723:
Adding a Leter to a Numerical Value on Exit
2724:
Little help with "Number stored as Text"
2725:
SpinButton Incrementing time behaviour
2726:
Sentence Capitalizatio
2727:
Error: DISP_E_TYPEMISMATCH while interop.excel
2728:
HTML INTO EXCEL
2729:
How to get variable from a formula
2730:
how to display error message?
2731:
write a macro to show the edit.find dialog box in excel
2732:
unloading XLL files in Excel
2733:
do until loop
2734:
Changing text to formula in a range of cells
2735:
A workbook of macros which runs on external workbooks.
2736:
file naming during auto-saveas
2737:
Move columns by selecting the day of the week
2738:
commission
2739:
page number display
2740:
Hide Blank rows from ListBox1
2741:
Excel Pre-2007 Menus Question
2742:
Activate macro in another book
2743:
Personal.xls Issues in Excel 2007
2744:
special sort option
2745:
Can't find project or library
2746:
formulas
2747:
inserting rows into worksheets
2748:
Run a macro from one excel file to another excel file
2749:
VB Msgbox result
2750:
Passing variables between excel files
2751:
Print separate PDF File for each group
2752:
Activating mozilla firefox and entering an address
2753:
Select....Case macro in Excel 2007
2754:
Splash Screen / userform
2755:
Print area multiple sheets
2756:
Automatically update data validation list
2757:
Changing the font size and color in a message box
2758:
need some array help
2759:
Golf match Leader board spreadsheet for recording up 200 players
2760:
out of memory error
2761:
Protect the structure of the workbook
2762:
Auto-formatting Time with a Query Table
2763:
Burberry Sunglasses SG_BU009 - www.luxury-gift.org
2764:
Armani Sunglasses SG_AR059 - www.luxury-gift.org
2765:
Dior Sunglasses SG_DI0704016 - www.luxury-gift.org
2766:
VB Syntax to close Excel workbook not saving changes
2767:
Error Upon Opening Excel
2768:
Get cell value from other workbook
2769:
Difficulty with macro in excel 2007.
2770:
Cannot remove password from file
2771:
get the sum of the value by filtering 3 columns
2772:
Slow VBA code?
2773:
Worksheet range copy
2774:
VBA for pivot tables
2775:
Set Focus On ComboBox
2776:
prevet users to view and modify MS query
2777:
Data concantating
2778:
Visual Basic Applications - Help Files
2779:
For Each Next... what's wrong with my code???
2780:
parsing Html page
2781:
Date Question
2782:
Positioning datalabels
2783:
excel macro with word
2784:
Calculation-problem
2785:
LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS
2786:
Displayed caption font increases on each click
2787:
Comparing multiple rows of data
2788:
Modifying code
2789:
HELP=> Problems Copying WorkBook Sheets
2790:
BIFF / Office 2007 Question
2791:
HLOOKUP Can't Search by Lookup Value
2792:
HLOOKUP Can't Search by Lookup Value
2793:
question on hiding rows
2794:
Column password protection
2795:
DATE ALARM
2796:
How could I make the contents of a Cell "Flash" like a warning.
2797:
ADO read of Access...
2798:
Cannot get message box to show
2799:
Investor's Knowledge Analysis
2800:
Opening a file from another file