TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 15
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
4901:
VBA CODE SOLVER TO RETURN VALUE
4902:
Renaming pictures
4903:
Reading data from Excel and Word tables
4904:
How I write "if cell value =>1, copy entire row & paste at dest.
4905:
Inserting Name in a cells
4906:
how to test whether selected variable is within defined range in V
4907:
Excel Column "SET Filter to " in one column count in another colu
4908:
lookup
4909:
insert rows by vba
4910:
Relative and Absolute Links
4911:
Cut and paste columns programmatically
4912:
Freeze Data in drop-down combo box list
4913:
Gary Student ? How do I add a For next to this.....Macro
4914:
Deleting rows with formulas
4915:
Change 'ENTER' key behaviour on different cells
4916:
Read next value?
4917:
Need VBA stript for column selection
4918:
How to show columns/cells in sheet but hide them in print?
4919:
Auto filter to all csv file in a folder.
4920:
Macros
4921:
Dilettante Question: VBA to VB.Net?
4922:
count IF cell IS yellow
4923:
Error '13' Type Mismatch
4924:
Export Arabic data in to Excel issue
4925:
Run time Error 13 Type Mismatch Excel 97
4926:
Disable "contacting the server for information" message?
4927:
Get Workbook Object properties without opening Workbook?
4928:
Need a macro to Copy data from one sheet and paste to child
4929:
INDEX & MATCH Help with syntax please...
4930:
Can't find libraries
4931:
Automatically run Macro before printing
4932:
Getting there but.....
4933:
getopenfilename <> this workbook
4934:
cursor movement on optionbuttons
4935:
VBA - checking for existance of a property
4936:
accept fractions from textbox
4937:
Error 424 for sample code?
4938:
color formatting from vbe
4939:
macro adjustment
4940:
Shortcut key to commandbutton
4941:
Excel Macros
4942:
Excel CDO mail
4943:
CDO mailing from Excel
4944:
looping through comma delimited text
4945:
VBA and VB6 functions return different answers?
4946:
Enumerate cell formulas
4947:
remove Add-In?
4948:
Find Help
4949:
Selecting File to do VLOOKUP From
4950:
For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3
4951:
find a value in a column then copy next few rows
4952:
Checkbox works in one window but not another
4953:
passing column character as subroutine parameter
4954:
from VBA to DLL VB6 for security's sake:recommendations sought
4955:
2003 2007 Code
4956:
Need a macro
4957:
Testing Blank Conditional Formatting
4958:
Conditional Formatting
4959:
Insert text from Comment in 3/4 TextBoxes in a Form
4960:
Remove Columns with header in row 1 but no data in remainder of co
4961:
Display a Line w/ Caption instead of Frame w/ Caption
4962:
Manipulating Multiple Versions of Excel, c#
4963:
Print Formating using VBA
4964:
Select a column within a query
4965:
How to avoid warning pop-up dialog boxes
4966:
UDF for dynamic custom lookup?
4967:
UD
4968:
Excel macro to copy row from one tab to another based on certain criteria
4969:
Referencing a row with a maximum value array?
4970:
referencing the actual row number? How?
4971:
Macro - move active cell to another column; same row
4972:
How do link the prolog output to an excel sheet.
4973:
How do link the prolog output to an excel sheet.
4974:
Data Source, auto populate rows and columns
4975:
ADO connection not opening in Excel 2003
4976:
Newbie here .
4977:
Pulling out numeric number from Activecell.Address
4978:
Passing array elements to a function
4979:
Turn display alerts off then back on at close
4980:
Choosing Active Cell
4981:
Fixed 'Find' or 'Look up'? cell - is it possible?
4982:
Writing a Sort Macro
4983:
Newbie w/question
4984:
Workbook Properties
4985:
How to retrace the execution path?
4986:
How to knwo the current statement
4987:
Copy value from formula result on event change of cell value
4988:
Data
4989:
using application.filesearch for searching text in PDF
4990:
VBAProject Protection
4991:
Conditional Formatting through VBA ODBC
4992:
Avoid Prompts on Workbook open?
4993:
Should I use Excel or the OWC11.spreadsheet control in a web page?
4994:
Hi all,
4995:
new Freeware Excel add-in for importing from ODBC data sources
4996:
Protecting Sheet
4997:
Delete Page Breaks -
4998:
Copy paste without selecting sheet or range
4999:
Open txt file without changing date
5000:
Using VLookUp
5001:
Excel Wscript Selection Problem
5002:
Handle an "Excel cannot complete..." alert window with
5003:
remove VBA codes while saving
5004:
epression REPLACE
5005:
username and password when login
5006:
help me(indirect function error)
5007:
Sticky interior colors
5008:
Validations with messages in userform
5009:
Macro to look up and match names?
5010:
Is it possible to link an Excel Workbook with a data base?
5011:
Globals Go "Poof!": Workarounds?
5012:
Finding attachment point for comment textbox
5013:
Excel 2007 - Format of New Documents
5014:
VB Macros for Charts - Fails (Office 2003 on WInXP Sp2)
5015:
Importing Microsoft Word to Excel
5016:
Security settings for Excel 2003 are lost on Vista 64 bit OS
5017:
Is it possible to change and entire worksheet to text?
5018:
profit margin based on prices
5019:
String Comparison
5020:
preselecting in combo box
5021:
task scheduling
5022:
Help with transpose?
5023:
Are you telling me all a virus has to do is run from XLSTART to
5024:
IF statement
5025:
Logging data to worksheet
5026:
Insert a Row - Variable Location
5027:
Which references will I need to reinstall on a new machine?
5028:
Unprotect entire sheet
5029:
Creating a macro to filter data on multiple sheets
5030:
Custom menu items in a copied workbook
5031:
Set Pivot Table Pages
5032:
Copy and paste every x number of cells
5033:
Application.FileSearch Problems
5034:
If cell 'a' matches cell 'b' then copy cell 'd' to cell 'e'
5035:
List all link cell to other workbooks
5036:
Help with Autofill
5037:
Run a Macro just after i open a workbook EXCEL
5038:
referring to a textbox on a different userform.
5039:
RTD Links retain previous values in certain conditions -- bug?
5040:
Run Time Error 3343 - Unrecognized database format:
5041:
AutoFilter Trigger Calculation
5042:
Pagefield - select "(All)"
5043:
Sum column values and insert result in last cell with VBA
5044:
Saving w/ Stronger Encryption in Excel 2007
5045:
Change in cell disabling events
5046:
send email macro with Outlook running
5047:
paste file name of an OFFice program into a cell
5048:
last record
5049:
Vacation Accrual
5050:
VBA - Copy paste all Modules
5051:
Excel 2007 data query parameter issue
5052:
Duplicate in Row
5053:
Sendmail, XL97 vs XL2k
5054:
Evaluate text formula in VBA
5055:
Sumproduct with Autofilter
5056:
Duplicate removal macro keeps newest record
5057:
Starting Outlook via FollowHyperlink event
5058:
VB Help If Statement in Selection.ShowDetail = True
5059:
activate code upon save command
5060:
Macro not running anymore
5061:
Sum all Cells with Interior Color Index not equal to 0
5062:
How do I use VBA or a function to do a certain type of string work
5063:
Pagebreaks vs page numbering
5064:
Is there a steep learning curve for excel 2008 VBA as opposed to
5065:
Problem with Worksheet_Activate event
5066:
How come code written by a macro won't replay in excel 2008?
5067:
Collect data from Excel files
5068:
Automation error
5069:
View workbook
5070:
Function that groups together Overtime hours by 7.5 hrs
5071:
Automatically Update Excel Graphs
5072:
copy data to combobox value sheet
5073:
List Problems
5074:
Use VBA to display record with criteria
5075:
Pivot table - sorting
5076:
CommandButtons have stopped working
5077:
How do I modify this macro to print the currently visible chart?
5078:
Viewing hidden data
5079:
Place TextBox Behind Other Controls on a Workshheet
5080:
Command Button
5081:
Filesearch won't clear
5082:
>= Greater than or Equal to Not working
5083:
Excel macro security fails in directory XLSTART.
5084:
Font color in userform controls.
5085:
User form- protection and password.
5086:
Does a Pivot External Source to SQL Server stay connected?
5087:
Open Office Outlook & Insert e-mail address
5088:
override old format
5089:
Formulas and Cumulative Values on a Line Chart
5090:
conditional format question
5091:
Problem using internetexplorer object to open a url
5092:
Easier Method
5093:
Difficulty with copy and paste
5094:
Concatenate
5095:
Date Format HELP
5096:
VBA Structure Charts
5097:
Adding images to cells via VB.Net
5098:
How to add an array to a combo box with Excel 2003?
5099:
Formatting Comments
5100:
xl2007 speed issues
5101:
Inserting Formula moving down each row
5102:
Update Add-in
5103:
Splitting cells
5104:
Event Fired when Calculation Mode Changed
5105:
Signature Authentication
5106:
Relative links to worksheets
5107:
Search and Find Missing In Action
5108:
Comparing
5109:
User Defined Functions to separate full names
5110:
Listing Occurences of a date
5111:
SharePoint Versions
5112:
Selecting Shapes
5113:
Adding Data Label value with VBA to a chart
5114:
Error 1004 - Unable to set invertifnegative
5115:
Conditional Formating
5116:
Dependent Validation List
5117:
Alternate row shading
5118:
Is there a way to skip lines (insert value every other line)
5119:
Locking Cells
5120:
Processing a Message Box w/in a Macro
5121:
VALIDATION FUNCTION HELP 2...
5122:
import multiple CSV files into one Excel file
5123:
End of Statement error
5124:
Goto ("A1") in non active sheet
5125:
CLEAR FIELD TEXT ON CLICK?
5126:
how to access column 8 in my Range
5127:
VALIDATION FUNCTION HELP
5128:
Adding up range of cells exclude hide cells
5129:
Excel Workbook.SaveAs xml spreadsheet gives garbage number
5130:
with a macro open a workbook without the Auto_Open running
5131:
Publishing a static table using jscript (Excel 2007)
5132:
formula in code
5133:
Color Change Syntax
5134:
Delete last sheet in workbook
5135:
Lookup from a list of numbers
5136:
format the cell Comment
5137:
Date field in user form & Loading a user form on opening workbook
5138:
copy row based on match and multiple criteria
5139:
2nd TRY: Up from 2003 to 2007; code now throws error creating
5140:
How do I make a cell truly empty using an "If" statement?
5141:
Multiselect listbox if no selection
5142:
Run-Time error '9' New Question
5143:
vba - Select Used Range minus the top header
5144:
Programmatically add worksheet function
5145:
excel 2000 to excel 2007
5146:
Procedure level array not recognised at module level
5147:
Limiting access to registry
5148:
1004 Error on Workbooks.Open when run from inside IE
5149:
Autocopy instead of autofill
5150:
accessing Outlook Address book from Excel VBA
5151:
Array function not working correctly if I use an "or - statement"
5152:
Build data from Invoices.
5153:
first space from the right
5154:
Need worksheet Event for Sum
5155:
Date Field Problem in Userform
5156:
Start Word within Excel 2007
5157:
VBA "Excel & Outlook" **************
5158:
triggering Workbook_SheetCalculate
5159:
Copy subtotal results
5160:
programming issue when using Excel automation
5161:
Super Hard Question
5162:
Macro doesn't record action on a chart
5163:
Re : Excel Chemistry Before and After
5164:
Finding cells with matching data
5165:
Replacing column values with formula values
5166:
don't want column width change after refresh
5167:
why does s.TextFrame.Characters.Text work only sometimes?
5168:
PrintPreview problem in 2007
5169:
Run-Time error 1004. Help Please!
5170:
how do find the actual macro file on hard drive to send?
5171:
Fast Way to Delete Rows from Big Spreadsheet (Using VBA)
5172:
url content
5173:
url content
5174:
Excel file on Treo to dial phone numbers
5175:
Excel 2003 Markers
5176:
text in file
5177:
2007 Copy Paste Disabled
5178:
Getting Worksheet_Change to Ignore First Row
5179:
Highlight row any random color using same random color with duplic
5180:
Setting a spreadsheet to auto sort data entry
5181:
Auto select rows
5182:
For...Next not copying text from Worksheet to Worksheet, but no Er
5183:
Ranges and Number Combinations
5184:
Ongoing Issue - I have tried to clarify so that you understand
5185:
Strip 2 Numbers from a Hyphenated Range
5186:
=?Utf-8?Q?Sections_of_Excel_2003_pivot_=E2=80=9Cbl?=
5187:
combining worksheets
5188:
Autofilter icons shifted to top row in Excel 2007
5189:
Problem Setting Worksheet
5190:
=?Utf-8?Q?1004_Error_in_VBA_Conditional_Fo?=
5191:
How to Populate an Array with a Discontiguous Values
5192:
VisibleRange references
5193:
Adding the next month to a daily volume tracking sheet.
5194:
Probably a rather basic question....
5195:
Textbox problem in Userform
5196:
changing date format
5197:
does the "Range"object in excel2007 vba still have 65k row limit?
5198:
Active chart screen visible coordinates
5199:
Loop through sheets and get number of records per sheet
5200:
Writing a VBA program
5201:
remote references and external link values
5202:
Help Loop question
5203:
How can I automatically split values over specified time periods?
5204:
select range
5205:
Displaying Data in Matrix
5206:
Combine two workbooks into one
5207:
Creating a custom toolbar add-in in Excel 2007
5208:
Workbook_SheetCalculate twice
5209:
Make Sheets.(Range 1) = Sheets.(Range 2)
5210:
DB2 timestamp format
5211:
Options for error output in custom Excel functions
5212:
Counting colored cells
5213:
Loop through sheets & filter main sheet using sheet name
5214:
Determine which variable was used in a calculation.
5215:
Data check
5216:
Count difference in days input box
5217:
Closing a recordset error : Operation is not allowed when...is clo
5218:
For To / Next loop doesn't update...
5219:
Macro for popup window " update values"
5220:
help with chart script and data labels
5221:
=?windows-1252?Q?Using_SendKeys_to_=91activate=92_a_tab_on_2007_Ribbo?=
5222:
Get templates files and copy data to it
5223:
RowNumber corrupts formatting of Querytable
5224:
Help to create worksheets from a list
5225:
Matching cells (Excel 2007)
5226:
Invisible sheets
5227:
Using Data>Validation cell formatting to drive OnEntry/Intersect m
5228:
VBA equiv. of Ctrl-Home w/Freeze Panes?
5229:
Autoshapes on Excel user forms
5230:
VBA, Search!!!! Help
5231:
File on taskbar
5232:
Error handling error # 1004 Run-time error
5233:
Catch name of range
5234:
VLOOKUP with two Workbooks
5235:
Delete all object
5236:
Conditional Formating
5237:
VBA Sumif *********************** Help
5238:
Check if data is inputed.
5239:
"Workbooks.Open" fails with 2007??
5240:
Code Needed for to check data input
5241:
sort entire range with exception of last row
5242:
VBA Time comparison not correct
5243:
Looping
5244:
Workbook Reopens After Close
5245:
cell color change with click and record the the time and date
5246:
Can't Click Anything
5247:
How to calculate a Max / min in a matrix
5248:
adjustine the range of a selected cell
5249:
Comma replacement
5250:
Excel crashes when I add VBA code programatically