TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 29
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
view full version:
back to formated view
9801:
editing data in database from Userform textbox
9802:
active workbook/sheet
9803:
Custom Header
9804:
Copy/paste new worksheet to master worksheet
9805:
mail sheet as body from userform
9806:
Math headache
9807:
RANGE MACRO
9808:
New funny recruitment video for Microsoft..
9809:
Schedule downloads in VBA
9810:
InputBox buttons
9811:
Find checkboxes and then check them
9812:
workbook_open() sub does not work
9813:
Connecting to Access
9814:
Macro Fault on Custom Ribbon
9815:
Selecting a range after activating a worksheet
9816:
Error Msg when opening Excel 2007
9817:
Code loops to death every time I attempt to add a string to a cell
9818:
Create a user-defined function
9819:
xlDialogImportTextFile txt file name
9820:
Macro to format text
9821:
having trouble disabling "save", "save as" (2003)
9822:
add names
9823:
Formula to VBA function (if and lookup)
9824:
Taking info from all sheets and compiling it without spaces
9825:
Copy/Paste Charts; Define Destination of Charts in PowerPoint
9826:
Groups in Option buttons
9827:
Next Worksheet in code
9828:
Determining if Button on worksheet is hidden
9829:
macro comparing values from 2 worksheets
9830:
E-mailing from Excel Q
9831:
disable shortcut key from menu control
9832:
Date Format
9833:
Solution: MSXML2.XMLHTTP with a TimeOut Value
9834:
Beginner stuff - Adding look-up box to spreadsheet
9835:
PC and Mac
9836:
loading automation add-in for an instance of Excel
9837:
Count and list items that are due
9838:
error
9839:
autofilter
9840:
Form not found
9841:
Using autofit on cells which include ASCII 10 (LF) character
9842:
Examples of "Front Office" usage of Excel
9843:
=?Utf-8?Q?Programmierhilfe_f=C3=BCr_eine_Listbo?=
9844:
Activating an open work book from text in a cell
9845:
"Read only" warning display
9846:
Select multiple but non sequential cells relative to a particular
9847:
Programming a macro to draw info from a list of links
9848:
Copy specified columns to another sheet
9849:
Enter the result of a formula using VBA
9850:
insert rows programmatically with formula change
9851:
Vlookup to VBA
9852:
Entering text in Excel cell
9853:
Vlookup syntax format
9854:
problem uninstalling an add-in
9855:
Unable to access any Programming capability
9856:
How to start Office application in Automation mode via Office itself?
9857:
Why does this code not work for me?
9858:
moving excel 2003 data to sql server
9859:
Copy from cell above
9860:
error opening a workbook
9861:
Using macros to condense a template
9862:
Sum Visible Cells Only
9863:
record the maximum value in a cell
9864:
Folder Contents to Excell
9865:
Error '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
9866:
Placeing data from sheet1 to sheet2 via a form button
9867:
Placeing data from sheet1 to sheet2 via a form button
9868:
Placeing data from sheet1 to sheet2 via a form button
9869:
Excel 2007 XmlMap.ExportXml producing empty string
9870:
Macro for copy
9871:
Are we back on line?
9872:
Data Fill in Visual Basic
9873:
Please HELP me!!
9874:
Auto Start Macro in Excel
9875:
Programming Outline Expand(+) / Collapse(-) Functionality
9876:
Copy IF condition exists
9877:
Inserting a row
9878:
Paste Special MS Excel Worksheet range selection into Outlook Task
9879:
Interior.Color from a function yields Error 1004
9880:
Insert a row
9881:
Create a task from a userform
9882:
Macro works - any suggestions on improvements?
9883:
Excel/SQL Problem
9884:
Need to get value of last number in a column
9885:
Macro works but is there a better way
9886:
XML Mapping - Update Schema
9887:
DsoFramer and Excel
9888:
finding charcters for UDF
9889:
select the data and copy in another sheet
9890:
Export To Xml
9891:
CHRW
9892:
Insert new column and paste formula
9893:
How to Diagnose Why "Code Execution has been interrupted"
9894:
disable a menu control short key
9895:
Referencing a named range in another workbook
9896:
VBA and Password Protection
9897:
Using the name in a cell to open/activate a workbook
9898:
Need value of last number in a column
9899:
check if excel sheet in manual calc mode
9900:
check if excel sheet in manual calc mode
9901:
Excel files linked
9902:
Disable all toolbars apart from custom toobar
9903:
Moving Spreadsheets with formulas attached, between workbooks.
9904:
Type Mismatch error
9905:
Check cell address for double alpha characters
9906:
create outlook task from excel
9907:
uninstall-add in
9908:
SQL and Excel problem
9909:
Code for running macro on save
9910:
uninstall add in
9911:
Alpha/Numeric help
9912:
search column and display results in msgbox
9913:
uninstall an add-in
9914:
Find String in Cell then Paste Sum in Offset Cell
9915:
vb code for data transfer
9916:
Date Picker Behaviour
9917:
paste special excel worksheet range into outlook task body
9918:
Copying a range to a separate excel database
9919:
Number format
9920:
Search from bottom of column up column and delete to top
9921:
Code to run macro on save
9922:
Form keeps the focus unable to get to code - HELP!
9923:
Nested If's
9924:
vlookup on changing range
9925:
selecting target sheet as an input
9926:
data arranging
9927:
Visual Basic Form
9928:
Files linked to one specific file.
9929:
about data copting
9930:
question on scope of a global variable
9931:
range as listbox column
9932:
Chartspace Data Source and Connection String Problem
9933:
Schedule Downloads
9934:
Schedule downloads
9935:
importing more than 65536 rows from .csv file
9936:
Schedule downloads
9937:
Changing cell color based on a value in another cell
9938:
Given Address, find named ranges that contain it
9939:
Alpha Numeric help
9940:
clearing duplicate values in Column A
9941:
Finding Maximum of Two Numbers in Array
9942:
touch screen with excel
9943:
Need help to have macro populate a column with formula to end of
9944:
Speeding up slow code
9945:
If data exists in column J, put formula in column K
9946:
Select Case
9947:
Excel Controls
9948:
Calculating column based on formula
9949:
CAN ANYONE PLEASE SOLVE MY PROBLEM
9950:
formula
9951:
vlookup working in one instance, but not another
9952:
Copy Chart and Insert in new Sheet as picture over the same location
9953:
Paste special function in macros fail if we disable application cell
9954:
Understanding and comparing stock market figures
9955:
Exception when adding a array formula
9956:
CORRECTION NEEDED
9957:
Text upside down!
9958:
Strnage bug when pasting charts
9959:
Running a Macro from another Macro
9960:
Value NOT placed in 2 sheets, but in ALL others
9961:
Everything You Need To Know About Printed Lanyards
9962:
Next Without For Error
9963:
creating sheets macro crashes after 26th sheet
9964:
Multiple IF Statements
9965:
Excel 2003 / VS 2005 Automation Add-In
9966:
Changing cell color based on value in another cell
9967:
SheetSelectionChange when modal form is shown
9968:
macro that identify the newest file in a folder and open it.
9969:
Programming SendKeys
9970:
Query SQL Server with concatenated text from Excel
9971:
Help Number formatting of actual data not just the view
9972:
Vlookup to VBA
9973:
setting a list in a combox doens't from a range
9974:
cell color condition
9975:
Data Retrieval from spreadsheet
9976:
Pivot table help
9977:
Find Text the Insert Sum
9978:
Find Text the Apply a SubTotal Next to Text Address
9979:
Cascading Combo Box & Content Filtering
9980:
Excel Chart Macro Issue
9981:
Digital clock that continuously updates from NOW()
9982:
Add line in existing macro to use template
9983:
Right Click menu doesn't appear in Page Break View
9984:
Query Update from Access: Re Ordering Columns
9985:
Excel 2003 vs Excel 2007?
9986:
show Comment using INDEX
9987:
Numberformat applied but does not change data
9988:
Defining a variable range
9989:
setting variable direction in visual basic
9990:
Capturing Undo Values
9991:
Adding and removing extra pages
9992:
Automate Data Entry from .xls to IE
9993:
Run Time Error 1004
9994:
Reading Values Between Sheets Based On The Condition
9995:
Code for export
9996:
Insert Symbol in VBA
9997:
How to capture the cell above
9998:
automatically input data into SAP R3 from Excel
9999:
find own user posts
10000:
Reset values in a combobox
10001:
take user clik as an input
10002:
Set array of objects to nothing
10003:
Macro to copy/paste
10004:
Copy to datasheet -Message for Ron De Bruin
10005:
Exiting a Sub when called from another Sub
10006:
Serial Order
10007:
Macro with vlookup with variable sheet
10008:
user can't use workbook when already open
10009:
Check/Option box from Excel list
10010:
Macro stops for no reason
10011:
Building a COM add-in...
10012:
Logical tests
10013:
Error: If Range("AZ" & intCounter).Text = "" Then
10014:
Data from Excel to Word bookmarks
10015:
Compare Two Rows Directly
10016:
close file -> open and save
10017:
2008->2003 incompatibility
10018:
EMPLOYEE WEEKLY SCHEDULE
10019:
zoom in &zoom out in VBA User Form
10020:
Select an empty cell
10021:
print each row in the list in the combo bos
10022:
Disabling the "Design Mode"
10023:
PasteSpecial issue
10024:
Code to get Max Value in a perticular cell in ALL Sheets
10025:
Userform problem
10026:
Tools/Customize question - toggle Show/Hide Comments without a macro
10027:
Excel 2007 retreive text from text file
10028:
Shade cell if No value in offset cell
10029:
Please Help Help$$ modifying the recorded (VBA) Macro with Excel
10030:
hiding rows with merged cells using macros
10031:
Using formula in a macro?
10032:
change event
10033:
using rowsource to fill a combobox
10034:
Day of Week
10035:
Control Number - A better way
10036:
Cell Update on Paste
10037:
Shortcut Key Assigned to Imported Macro (i.e. in personal.xls) Does Not Work
10038:
Should TD be HTMLTableCell?
10039:
getting the entire range before be filtered
10040:
Loop through table of columns and rows
10041:
additem removeitem
10042:
Macro to schedule downloads
10043:
Help me to first row matching First date and last row matching last
10044:
Excel workbook save behavior using VB6 very confusing
10045:
Delete Specific Sheets
10046:
How to Place a Drawing Object on a Worksheet as a Control?
10047:
Macro Copy Excel Chart Sheet to PowePoint - Mod of Jon Peltier code
10048:
DialogActiveCellFont
10049:
Need to paste/update info to correct row.
10050:
Return Control to Userform
10051:
List Box Highlight Selection from Sheet
10052:
How to populate web page forms from Excel or DB? Is this possible?
10053:
Match function not wokring on 2D array
10054:
automatically create list of the worksheets
10055:
Issue with marco for entire workbook
10056:
find error
10057:
How to install missing DBNamespace 1.0 Type Library
10058:
Find first empty row in a range
10059:
automating (alt & f11)
10060:
Automatic Toolbar
10061:
writing a text file in the same folder as my program
10062:
Stripping HTML tags from excel
10063:
Set message subject here ...
10064:
Tip # 14 To color all sheets in the workbook
10065:
Excel has encountered a problem and needs...
10066:
macro to return value of worksheets
10067:
referencing to external name range that would update automatically
10068:
Sorting problem
10069:
Linked file Excel 2007
10070:
Excel file linking
10071:
Excel tables vs. system tables
10072:
Running macro in one workbook that refers to variable in another
10073:
Delete Row Select Case
10074:
I have the slowness problem also
10075:
match function - date and time
10076:
Subroutine Summing and Outlining
10077:
Getting a range using row & col numbers?
10078:
Retrieve selected data from Network file
10079:
Error Handling Help
10080:
alt & f11 via macro
10081:
too much space
10082:
User Form
10083:
Cannot hide columns/rows
10084:
combobox dropdown
10085:
how to identify a shape as a picture in excel from VB
10086:
error 70 permission denied in excel
10087:
prefix in text box
10088:
E-Mailing macro font options
10089:
Formula for day of the week to relate to corresponding date cell
10090:
Checking Web Queries
10091:
add total from 6 textboxes and put in label
10092:
last cell as label caption
10093:
show userform/hide workbook
10094:
Naming Ranges with code
10095:
Displaying programatically worksheet errors messages in a cell
10096:
Insert Row & format as per other rows, above/below
10097:
manipulating Query data 'on the fly'Question
10098:
lastcell
10099:
"Toggle Switch" help needed
10100:
force text/numbers in text box
10101:
range value as label caption
10102:
Addins - number of columns & rows in running version of Excel
10103:
Triggering macro
10104:
Select a series of cells
10105:
Searching for a value for and then replacing when found.
10106:
Concert number to time
10107:
Ok what's the trick to do this?
10108:
How to extract aggregate values from PivotTable
10109:
Conditional formatting
10110:
Cancel Button on file save
10111:
Problem in automating using a button created by recording a macro
10112:
test
10113:
recently used file
10114:
Saving multiple worksheets to a master file
10115:
Excel Macro: Selecting items from another worksheet without
10116:
loop help
10117:
Loop help
10118:
Sort Data auto on cell range when updated
10119:
Add dimesion to Array already populated
10120:
Copy & Paste Dynamic Named Range
10121:
Help with code
10122:
Help! Refrence a userform element from a textbox?
10123:
Help! Refrence a userform element from a textbox?
10124:
Create VBA function that returns many values
10125:
Shell Command Fails (sometimes)
10126:
Atofill Questions
10127:
Passing result of multiple split function results to 1 Array
10128:
sheets
10129:
How to copy from each sheet and paste to a summary sheet
10130:
Prevent a Worksheet from being deleted
10131:
Get Save Prompt when closing workbook immediately after saving
10132:
how to save a file and overwrite existing file
10133:
Date and Time
10134:
MS Excel 2007. ActiveChart.ApplyCustomType
10135:
Restore "Delete..." and "Insert..." shortcuts
10136:
Using Excel Interop via VS.NET 2005 to create and save a new Excel
10137:
"Call" Commandbutton1()
10138:
Excel 2007 VB function call return value syntax question
10139:
Office 2007 VBA Compatibility??
10140:
Filter and count hidden cells problem
10141:
Set position of non frooze rows when panes are frooze
10142:
Multipage Tab vs Regular Userform
10143:
Extracting Text between 2nd and 3rddelimiter
10144:
how would i wrtie this formula
10145:
VBA for Exporting to Text file
10146:
Opening workbook in same directory
10147:
passing an argument
10148:
Show Time Stamp in Cell when Command Button Clicked
10149:
dynamic source range change in pivot table
10150:
Copying across values based on criteria