TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Programming Archive
‹
Page 21
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
7001:
how to allow insert hyperlink and grouping together under protecti
7002:
Application Crash Whie adding Code lines using VBA
7003:
Hiding rows only when a condition has been met
7004:
How do I invoke the "Reset" button in the VB Editior via code?
7005:
Copy from one workbook to another
7006:
Exclude Leading Blank Rows From Selection
7007:
ADO sql server password
7008:
how do i protect one cell for write but not for select?
7009:
Workbook_SheetChange event
7010:
How to Execute macro after importing external data ranges
7011:
Pivot Tables and Macros
7012:
Worksheet Tabs
7013:
Can I programmatically access the MS Office Clipboard?
7014:
How to enforce input and delete order of cells?
7015:
Dropdown list to populate sheet
7016:
Vlookup then subtotal
7017:
Delete rows if value matches
7018:
Array of Charts in Excel
7019:
Find Command
7020:
protect formulas only
7021:
Lotus Notes get all the recipients
7022:
to Ron de Bruin Please
7023:
Nested Search and Replace
7024:
combobox fraction
7025:
This is killing me
7026:
Need help adding If/Then/Else Statement
7027:
Model User Forms
7028:
is there a "workbook.calculation" command ??
7029:
Generate list of number
7030:
How to remove carriage return symbol before importing into excel
7031:
remove vba code before emailing as attachment
7032:
Textbox value - rename worksheet with
7033:
hiding pivot tables
7034:
updating macros
7035:
How to change process bar % when macro is running
7036:
Returning the IP results from a ping?
7037:
Converting pdf tables into Excel files
7038:
How to stop macro with cancel button
7039:
RemoveDuplicates not removing all duplicate entries
7040:
How do I disable "save as the new xml format for additional securi
7041:
Looping Listbox in Userform
7042:
Activate the cursor in a cell
7043:
return ADO record set from Add-In?
7044:
How do I direct a macro to a newly opened workbook
7045:
looping struggle with index/match
7046:
Print Selection
7047:
ActiveWorkbook.SendMail and IE - odd problem
7048:
Adding button to worksheet
7049:
Status Bar Freezing 2nd Try
7050:
Links broken when spreadsheet emailed
7051:
Screen Updating For Status Bar
7052:
How to "step into" in the middle of a long piece of code
7053:
XML schema validation fails
7054:
Macro additional information
7055:
search button on sheet (ctrl+f)
7056:
Buttons don't show
7057:
Changing a variable which is to be specified through a loop
7058:
Listbox to Array
7059:
excel 2000 help
7060:
Text Orientation in Published Worksheet
7061:
Open / Close Grouping through VBA
7062:
Loop to move #'s from one column to next
7063:
Macro - Search one book, replace with data from another
7064:
same sheet copy/paste special
7065:
Initiating Excel VBA Code From Access
7066:
use part of date in cell for save as name
7067:
help with part of my macro
7068:
Maintaining a list of unique entries in a list
7069:
Uppercase Check
7070:
replace . to / in dates
7071:
How to Pass a date from a calendar control to a field on a form
7072:
Most non built-in command bars invisible in Excel 2007...
7073:
Combo control to execute code BEFORE change - please help
7074:
Protect/hide VB code?
7075:
How to give combo box the focus
7076:
can I force formula to be applied automatically?
7077:
Excel Cell Comments
7078:
What keystrokes indents/outdents a block of code?
7079:
copy paste code not working(troubleshoot pls)
7080:
copy data in turqouise colour cells from n to a
7081:
Please Help! Need to add a Variable Range in my Excel Macro with
7082:
Including ActiveX Controls in Names Range Selection
7083:
Can't perform requested operation in excel macro
7084:
Excel Footer
7085:
importing data from closed Excel workbook
7086:
Using ADO to query CSV with no unpredictable headings
7087:
Shname = Array("Sick Graph","Accident Graph")
7088:
Complicated replacement values in list issue
7089:
Please help on coding
7090:
Message box
7091:
Assigning array values to seriescollection
7092:
Custom AutoFilter to Compare Due Dates to Current Date
7093:
highlight duplicate rows comparing two cells
7094:
Extend a Range
7095:
importing data from closed workbook
7096:
How do I goto column B in the current row using VBA?
7097:
#VALUE! from Function()...Posted in Excel General Questions by mis
7098:
Issue with File Name changing in cell
7099:
How to read xml file using VBA macro
7100:
copy/paste special
7101:
vlookup STRANGE
7102:
Macro File path problem
7103:
Problem with ranges
7104:
Pause to select cell
7105:
Text Import Wizard
7106:
Adding sum to varying columns lengths
7107:
how to save *.xls in a DB in Acces
7108:
USEING IF FUNCTION TO COPY IN ANOTHER WORKBOOK
7109:
vba code on seperate excel file
7110:
Zero Division
7111:
macro to open an existing email message
7112:
Macro
7113:
Match , copy paste (using find?)
7114:
Enter NA() into All Blank Cells in Range
7115:
Range as a variable
7116:
How do I prevent an error from crashing my macro?
7117:
Printing Consecutive Number (One spreadsheet) on Each Sheet
7118:
One macro two versions
7119:
Dynamically select range
7120:
Force a File to Open in a New Excel Instance
7121:
Using ADO to insert values into CSV file
7122:
Loop thru folders
7123:
Combining sheets with variable layout
7124:
Mouse rollover pop-up message
7125:
convert multiple sheets into PDF
7126:
Execute VB code against certain open workbooks
7127:
keeping an object in view
7128:
Boolean Declaration
7129:
Copy a Cell with a macro
7130:
Tab Function for textboxes on Worksheet not UserForm
7131:
Rename Tab with Textbox on Worksheet
7132:
.find not finding formula result
7133:
Convert Input String Formula to Number
7134:
Adding an alarm
7135:
Dynamic Workbook in VBA
7136:
Identity Specification
7137:
Find empty cell and input data for other cells
7138:
Code to Follow Hyperlink to media player without a new window opening
7139:
Format particular words in a string
7140:
Macro to copy a certain a cell to a dynamic range
7141:
Automatic Sheet Naming
7142:
Automatic Sheet Naming
7143:
Saving Excel Workbook to a stream using Excel 2007 Plug-in
7144:
it training institutes details ............
7145:
select, copy and past all cells with specific colour
7146:
Error: Type mismatch
7147:
.Value 9999 not recognised
7148:
ADO Syntax proble
7149:
Excel Data to Powerpoint
7150:
Enhance sub to paste charts as well
7151:
Pivot Table from external CSV file using VBA
7152:
Help on coding?
7153:
Insert column and hide columns
7154:
Using Caller with sub-menu selection in 2007
7155:
Userform close
7156:
Excel addin - how to deploy?
7157:
VBA Continuation Lines, Best Practices Mar08
7158:
IMPORTANT!Conditionally formatting just 2 of many characters in a
7159:
Passing ranges to a subroutine
7160:
Using ADO to Excel with this Query will not work?
7161:
Rename first X number of worksheets predefined names
7162:
Stuck and need help
7163:
Opening a Workbook within VB
7164:
Error saying Control object does not have Enable property.
7165:
Macro to convert mmddyyyy format into mm/dd/yyyy format
7166:
ActiveSheet.QueryTables.Add
7167:
Disappearing Images
7168:
Display Math Equation in Userform
7169:
Help modify macro
7170:
'Composing' numbers
7171:
Paste special validation
7172:
Public Sub ProcessData()
7173:
FILE 2 SLOW
7174:
checkbox centered in cell
7175:
How to permanently activate Macros?
7176:
Copying Worksheets from one workbook to another
7177:
pick from list and automatically enter corresponding cell
7178:
extract data from Outlook
7179:
Hyperlink Underline
7180:
Named Constant
7181:
assign Drop Down selections with values
7182:
Multiple questions
7183:
Error Trapping on Data Entry
7184:
Worksheet_Change - initiate macro on another worksheet
7185:
select cells with this/that colour with macro
7186:
web query for driving directions
7187:
if cell text repeats, move the adjacent column to the same row
7188:
Macro to put records of same person on same row and delete duplica
7189:
Passing reference to a checkbox to a subroutine.
7190:
Conditional formats
7191:
Delete rows based on an array
7192:
Help wCombo Box Setup
7193:
RTD issue with Excel 2007
7194:
Finding and copying from 1 worksheet to another.
7195:
Referencing an Excel Name from a different Workbook in VBA
7196:
Error 800a01a8
7197:
Shared Workbook - "1/0/1900" displays for some users
7198:
.Refresh BackgroundQuery:=False
7199:
dim problem when using cell() reference
7200:
Column Combinatorics
7201:
Help with external drop down lists
7202:
Getting around Protected Worksheet (number format)
7203:
Undo problems... again *sigh*
7204:
Variable headers
7205:
How to return mulitple values based on the contents of another cel
7206:
Email Formatting
7207:
Urgent Help
7208:
Export range to XML?
7209:
reorganising data
7210:
Image Enhancement Software... 3D... Cool Freeware
7211:
GetOpenFileName + Type Mismatch error
7212:
Please help me edit this code..Thanks in advance :-)
7213:
Excel email attachment from outlookexpress
7214:
Conditional formatting - based on indentation
7215:
How do I add the sum of a multiplication formula to another cell
7216:
Excel application logs
7217:
Excel queries
7218:
Copy data to next empty row in a range
7219:
Delete specific menu item from custom menu
7220:
Can Excel pull live information from the Web???
7221:
copying data in a sheet to a new Word document problem
7222:
Your favorite Excel Add-ins
7223:
Error handler question in Worksheet_Change event
7224:
Excel registry key
7225:
parameter
7226:
Parse email text
7227:
Disable Shortcuts
7228:
Modeless Userform
7229:
Custome Format Alpha
7230:
name the sheet the same as the file name
7231:
Quick Access Toolbar
7232:
A better way to get Min and Max date
7233:
Minimise/Restore
7234:
Changing case in a cell
7235:
weekly totals
7236:
Refer to combox from activecontrol name
7237:
formula that once it is true info stays in new cell?
7238:
Counting Colored Cells
7239:
how to save in the excel some additional invisible information
7240:
SORTING MACRO TO CLEANUP MESSY SHEET
7241:
macro/vba
7242:
Disappearing Personalised settings
7243:
Create New Sheets from Filtered List - help on macro
7244:
Rich Text Box
7245:
Searching a Word Document from Excel
7246:
Startup
7247:
Free Tutorial website And Ebooks programing tutorials
7248:
how secure is projectProperty Protection?
7249:
how to have checkBox in ToolBar (Icon) ?
7250:
Colouring cells based on day of week?
7251:
Variables & strings
7252:
Can you write the contents of an Excel Named Range to Word?
7253:
range and visibility
7254:
How to paste a image into a VB UserFrame in Excel?
7255:
Help with code please !!!
7256:
multiply text and number
7257:
Userform driving me insane
7258:
Vertical Line in an XY Chart at Today's Date
7259:
MenuBar/CommandBar(s) reappearing after being disabled??
7260:
Macro to understand how wide or long the data range is
7261:
If source cell is bolded then destination cell becomes bolded too.
7262:
need macro to repeat two rows at top of each page
7263:
check if any cell in column A has text
7264:
nothing selected in listbox, but listindex <> -1
7265:
macro to repeat non contiguous rows at top of ea page
7266:
How do I make a copy of a macro?
7267:
Hide Zero Rows - But Not Blank Rows
7268:
Behavior - Option Buttons
7269:
Lop to delete rows
7270:
Code for Copying and Pasting data to a separate Workbook
7271:
Batch file rename macro
7272:
VBA How to
7273:
Windows API Functions
7274:
Boost up Your Business through Data Entry Outsourcing By saving time
7275:
random number generator for scientific simulation purposes
7276:
Enable/Disable Macro
7277:
Excel Chart
7278:
Copy Values based on a Match Q
7279:
Conditional Formatting based on multiple criteria
7280:
why do hyperlinks on userforms in excel work but not word
7281:
Recommend: object intermediate between Application and Project
7282:
Excel 2003 - Writing a Macro - How Do I...?
7283:
how to insert a row at regular intervals of row
7284:
split in vba
7285:
Help with Design
7286:
Question about the Queue of Commands in Undo
7287:
Need VBA/Macro help in Excel (I think)
7288:
Days360 Formula in VBA error
7289:
Creating new worksheets and appending data from multiple worksheets.
7290:
Automated e-mail from Excel
7291:
loop through matches
7292:
TreeView Control V - 6.0 - Drag-Drop Nodes
7293:
Formulas
7294:
Macros?
7295:
macro to add leading zeroes to number and loop
7296:
Weird Happenings
7297:
formuls
7298:
If row 2
7299:
Carts and Acticesheet.Range
7300:
All for insert of picture on Protected Sheet
7301:
COPY...........(need a little change in a macro)
7302:
User Defined not defind
7303:
Freeze Panes- Windows Split
7304:
VBA code disables Undo command
7305:
How to enter a constant sum formula using values from 2 different
7306:
Outlook
7307:
Plot grand totals on secondary axis in PivotCable
7308:
how to find whether linked data exists
7309:
Formatting based on a condition
7310:
VB Scrpit to input search results in Excel work book
7311:
Excel VBA - Graph/Chart on Userform
7312:
VBA help. Select dynamic workbooks.
7313:
Refedit problems after installing SP3 to Office 2003
7314:
Excel Sorting In VB
7315:
Debugging
7316:
Create Worksheets based on column data
7317:
Excel Sorting in VB
7318:
Date Formatting
7319:
Screen Updating
7320:
Programmatically creating hyperlinks
7321:
toolbars
7322:
Find the next Cell with interior color using Do Until...Loop
7323:
Macro That Tests
7324:
Create folders from excel
7325:
UserForm to delete unwated items off sheet?
7326:
Storing result of function directly in a variable instead of cell.
7327:
How to Query the Database
7328:
Duplicating Changes from Column A and B of Master Workbook to Column
7329:
Duplicating Changes from Column A and B of Master Workbook to Column
7330:
Problem with second count routine from userform
7331:
Autoclose excel file after x minutes of inactivity
7332:
Need window handle for a userform
7333:
Saving date as part of filename
7334:
Dave - Trouble finding posts
7335:
Number of files in a folder including sub-folders
7336:
Lookup first/last column of record
7337:
SheetChange for formulas
7338:
SplitRange
7339:
Opening Excel File from value in active cell
7340:
How to disconnect the line for Internet?
7341:
Menu item
7342:
Private Sub Worksheet_Change doesn't work?
7343:
Avoiding IF limits with VBA
7344:
On Error Resume Next not stopping pop up message
7345:
Question with Solver code using "Application.Run"
7346:
Need a 'Refresh' button
7347:
Dropdown Box Conversion
7348:
Hide Autofilter Button but keep the filter on
7349:
Open Workbook Read Only and hide select worksheets
7350:
Combobox list appears on far left side of screen